DBA Data[Home] [Help]

APPS.PAY_HK_MPF dependencies on PER_TIME_PERIODS

Line 26: per_time_periods ptp

22: ptp.start_date,
23: ptp.end_date,
24: bal.value
25: from pay_hk_mpf_ri_balances_v bal,
26: per_time_periods ptp
27: where bal.assignment_id = p_assignment_id
28: and bal.balance_name = 'MPF_RI'
29: and bal.payroll_id = ptp.payroll_id
30: and bal.expiry_date between ptp.start_date and ptp.end_date