APPS.PAY_HK_MPF dependencies on PAY_HK_MPF

Line 1: PACKAGE BODY pay_hk_mpf AS

1: PACKAGE BODY pay_hk_mpf AS
2: /* $Header: pyhkudfs.pkb 120.15 2011/08/15 00:28:37 jalin noship $ */
3: FUNCTION get_retro_mpf(p_bus_grp_id in NUMBER,
4: p_assignment_id in NUMBER,
5: p_date_from in DATE,

Line 39: from pay_hk_mpf_ri_balances_v bal,

35: ptp.start_date,
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

Line 448: END pay_hk_mpf;

444: return l_act_term_date;
445:
446: END get_act_termination_date;
447: --
448: END pay_hk_mpf;