DBA Data[Home] [Help]

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.2.12010000.3 2008/08/06 07:23:19 ubhat ship $ */
3: FUNCTION get_retro_mpf(p_bus_grp_id in NUMBER,
4: p_assignment_id in NUMBER,
5: p_date_from in DATE,

Line 25: from pay_hk_mpf_ri_balances_v bal,

21: bal.balance_name||bal.database_item_suffix,
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

Line 378: END pay_hk_mpf;

374: return l_act_term_date;
375:
376: END get_act_termination_date;
377: --
378: END pay_hk_mpf;