VIEW: APPS.PAY_HK_RELEVANT_INCOME_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)