View: PAY_NZ_BALANCES_BY_DATE_V

Product:	PAY - Payroll
Description:	New Zealand localisation view.
Implementation/DBA Data:	APPS.PAY_NZ_BALANCES_BY_DATE_V

View Text

SELECT PAF.ROWID ROW_ID
, PAF.ASSIGNMENT_ID
, PBT.BALANCE_TYPE_ID
, PBT.BALANCE_NAME
, SES.EFFECTIVE_DATE
FROM PAY_BALANCE_TYPES PBT
, PER_ASSIGNMENTS_F PAF
, FND_SESSIONS SES
, PAY_RUN_RESULT_VALUES PRRV
, PAY_RUN_RESULTS PRR
, PAY_BALANCE_FEEDS_F FEED
, PAY_ASSIGNMENT_ACTIONS PAA2
, PAY_PAYROLL_ACTIONS PPA
WHERE ( PBT.LEGISLATION_CODE IS NULL OR PBT.LEGISLATION_CODE = 'NZ')
AND SES.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND SES.SESSION_ID = USERENV( 'SESSIONID')
AND PBT.BALANCE_TYPE_ID = FEED.BALANCE_TYPE_ID
AND PRR.RUN_RESULT_ID = PRRV.RUN_RESULT_ID
AND FEED.INPUT_VALUE_ID = PRRV.INPUT_VALUE_ID
AND PRRV.RESULT_VALUE IS NOT NULL
AND PRRV.RESULT_VALUE <> '0'
AND PPA.PAYROLL_ACTION_ID = PAA2.PAYROLL_ACTION_ID
AND PPA.EFFECTIVE_DATE <= SES.EFFECTIVE_DATE
AND PAA2.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID
AND PAA2.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID GROUP BY PAF.ROWID
, PAF.ASSIGNMENT_ID
, PBT.BALANCE_TYPE_ID
, PBT.BALANCE_NAME
, SES.EFFECTIVE_DATE

Columns