View: PAY_HK_ASG_MPF_DATA_V

Product:	PAY - Payroll
Description:	Hong Kong localisation view.
Implementation/DBA Data:	APPS.PAY_HK_ASG_MPF_DATA_V

View Text

SELECT PRR.ASSIGNMENT_ACTION_ID
, PRR.RUN_RESULT_ID
, PRRV2.RESULT_VALUE PERIOD_START_DATE
, PRRV3.RESULT_VALUE PERIOD_END_DATE
, PAY_HK_PAYSLIP_ARCHIVE.GET_ASSESSED_RI(PRR.RUN_RESULT_ID) ASSESSED_RI
FROM PAY_INPUT_VALUES_F PIVF2
, PAY_RUN_RESULT_VALUES PRRV2
, PAY_RUN_RESULT_VALUES PRRV3
, PAY_INPUT_VALUES_F PIVF3
, PAY_ELEMENT_TYPES_F PETF
, PAY_RUN_RESULTS PRR
WHERE PIVF2.INPUT_VALUE_ID = PRRV2.INPUT_VALUE_ID
AND PIVF2.NAME = 'PERIOD START DATE'
AND PIVF3.INPUT_VALUE_ID = PRRV3.INPUT_VALUE_ID
AND PIVF3.NAME = 'PERIOD END DATE'
AND PIVF2.LEGISLATION_CODE = PETF.LEGISLATION_CODE
AND PIVF2.LEGISLATION_CODE = PIVF3.LEGISLATION_CODE
AND PETF.LEGISLATION_CODE = 'HK'
AND PETF.ELEMENT_TYPE_ID = PIVF2.ELEMENT_TYPE_ID
AND PETF.ELEMENT_TYPE_ID = PIVF3.ELEMENT_TYPE_ID
AND PETF.ELEMENT_TYPE_ID = PRR.ELEMENT_TYPE_ID
AND PRR.RUN_RESULT_ID = PRRV2.RUN_RESULT_ID
AND PRR.RUN_RESULT_ID = PRRV3.RUN_RESULT_ID
AND PETF.ELEMENT_NAME IN ('INITIAL VALUES MPF'
, 'MPF LIABILITY'
, 'MPF WITHHELD'
, 'RETRO MPF LIABILITY'
, 'RETRO MPF WITHHELD'
, 'VOLUNTARY MPF LIABILITY'
, 'VOLUNTARY MPF WITHHELD')

Columns