Product: | PAY - Payroll |
---|---|
Description: | Australian localisation view. |
Implementation/DBA Data: | APPS.PAY_AU_BALANCES_MATRIX_V |
SELECT PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_NAME
, PBT.BALANCE_TYPE_ID
, PAA.PAYROLL_ACTION_ID
, PAA.ASSIGNMENT_ID
, HR_AUBAL.CALC_ASG_RUN_ACTION( PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID ) ASG_RUN_BAL
, HR_AUBAL.CALC_ASG_PTD_ACTION( PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID ) ASG_PTD_BAL
, HR_AUBAL.CALC_ASG_MTD_ACTION( PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID ) ASG_MTD_BAL
, HR_AUBAL.CALC_ASG_QTD_ACTION( PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID ) ASG_QTD_BAL
, HR_AUBAL.CALC_ASG_YTD_ACTION( PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID ) ASG_YTD_BAL
, HR_AUBAL.CALC_ASG_FY_YTD_ACTION( PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID ) ASG_FY_YTD_BAL
, HR_AUBAL.CALC_ASG_FY_QTD_ACTION( PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID ) ASG_FY_QTD_BAL
, HR_AUBAL.CALC_ASG_CAL_YTD_ACTION( PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID ) ASG_CAL_YTD_BAL
, HR_AUBAL.CALC_ASG_FY_YTD_ACTION( PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID ) ASG_FBT_YTD_BAL
, HR_AUBAL.CALC_ASG_FY_QTD_ACTION( PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID ) ASG_FBT_QTD_BAL
, HR_AUBAL.CALC_ASG_TD_ACTION( PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID ) ASG_TD_BAL
FROM PAY_BALANCE_TYPES PBT
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_RUN_RESULT_VALUES PRRV
, PAY_RUN_RESULTS PRR
, PAY_BALANCE_FEEDS_F FEED
, PAY_ASSIGNMENT_ACTIONS PAA2
WHERE ( PBT.LEGISLATION_CODE IS NULL OR PBT.LEGISLATION_CODE = 'AU')
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 PAA2.ACTION_SEQUENCE <= PAA.ACTION_SEQUENCE
AND PAA2.ASSIGNMENT_ACTION_ID = PRR.ASSIGNMENT_ACTION_ID
AND PAA2.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID GROUP BY PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_NAME
, PBT.BALANCE_TYPE_ID
, PAA.PAYROLL_ACTION_ID
, PAA.ASSIGNMENT_ID