View: PAY_GB_BALANCES_MATRIX_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_GB_BALANCES_MATRIX_V

View Text

SELECT PAA.ASSIGNMENT_ACTION_ID
, PBTTL.BALANCE_NAME
, PBT.BALANCE_TYPE_ID
, PAA.PAYROLL_ACTION_ID
, PAA.ASSIGNMENT_ID
, HR_GBBAL.CALC_ASG_RUN_ACTION( PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID ) ASG_RUN_BAL
, HR_GBBAL.CALC_ASG_PROC_PTD_ACTION( PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID ) ASG_PROC_PTD_BAL
, HR_GBBAL.CALC_ASG_TFR_PTD_ACTION( PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID ) ASG_TFR_PTD_BAL
, HR_GBBAL.CALC_ASG_YTD_ACTION( PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID ) ASG_YTD_BAL
, HR_GBBAL.CALC_ASG_TD_YTD_ACTION( PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID ) ASG_TD_YTD_BAL
, HR_GBBAL.CALC_ASG_STAT_YTD_ACTION( PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID ) ASG_STAT_YTD_BAL
, HR_GBBAL.CALC_ASG_ITD_ACTION( PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID ) ASG_ITD_BAL
FROM PAY_BALANCE_TYPES_TL PBTTL
, 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
, PER_ALL_ASSIGNMENTS_F ASG
, PAY_PAYROLL_ACTIONS PAYR
WHERE PBT.BALANCE_TYPE_ID = PBTTL.BALANCE_TYPE_ID
AND PBTTL.LANGUAGE = USERENV('LANG')
AND ((PBT.LEGISLATION_CODE IS NULL
AND PBT.BUSINESS_GROUP_ID IS NULL) OR PBT.LEGISLATION_CODE = 'GB' OR PBT.BUSINESS_GROUP_ID = ASG.BUSINESS_GROUP_ID)
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
AND ASG.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PAYR.PAYROLL_ACTION_ID = PAA2.PAYROLL_ACTION_ID
AND PAYR.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE GROUP BY PAA.ASSIGNMENT_ACTION_ID
, PBTTL.BALANCE_NAME
, PBT.BALANCE_TYPE_ID
, PAA.PAYROLL_ACTION_ID
, PAA.ASSIGNMENT_ID

Columns