DBA Data[Home] [Help]

APPS.PAY_HK_MPF dependencies on PER_TIME_PERIODS

Line 40: per_time_periods ptp

36: ptp.end_date,
37: bal.value,
38: to_number(to_char(bal.effective_date,'MM'))
39: from pay_hk_mpf_ri_balances_v bal,
40: per_time_periods ptp
41: where bal.assignment_id = p_assignment_id
42: and bal.balance_name = 'MPF_RI'
43: and bal.payroll_id = ptp.payroll_id
44: and bal.expiry_date between ptp.start_date and ptp.end_date