View: PAY_HK_RELEVANT_INCOME_V

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

View Text

SELECT BBD.PAYROLL_ID
, BBD.ASSIGNMENT_ID
, BBD.VALUE
, BBD.EXPIRY_DATE
, PTP.START_DATE PERIOD_START_DATE
, PTP.END_DATE PERIOD_END_DATE
FROM PAY_HK_BALANCES_BY_DATE_V2 BBD
, PER_TIME_PERIODS PTP
WHERE BBD.DATABASE_ITEM_SUFFIX = '_ASG_RI_PTD'
AND BBD.BALANCE_NAME = 'MPF_RI'
AND BBD.PAYROLL_ID = PTP.PAYROLL_ID
AND BBD.EXPIRY_DATE BETWEEN PTP.START_DATE
AND PTP.END_DATE
AND BBD.ACTION_SEQUENCE = (SELECT MAX(BBD2.ACTION_SEQUENCE)
FROM PAY_HK_BALANCES_BY_DATE_V2 BBD2
WHERE BBD2.ASSIGNMENT_ID = BBD.ASSIGNMENT_ID
AND BBD2.DEFINED_BALANCE_ID = BBD.DEFINED_BALANCE_ID
AND BBD2.EXPIRY_DATE = PTP.END_DATE)

Columns