Scope DeptID Value not passing through when using different query

I have a scope created for a single department. Now in the matrix layout, I have a column with the SQL below

The department is not passing through to this query and returns no results in the nvision report, even though the query returns results for the department that is being scoped on.

SELECT C.BUSINESS_UNIT, C.ACCOUNT, C.DEPTID, C.FUND_CODE, C.CLASS_FLD, C.MONETARY_AMOUNTFROM PS_KK_SOURCE_HDR A, PS_KK_SOURCE_LN B, PS_KK_ACTIVITY_LOG CWHERE ( A.KK_TRAN_ID = B.KK_TRAN_IDAND A.KK_TRAN_DT = B.KK_TRAN_DTAND B.KK_TRAN_ID = C.KK_TRAN_IDAND B.KK_TRAN_DT = C.KK_TRAN_DTAND B.KK_TRAN_LN = C.KK_TRAN_LN)