APPS.PAY_IE_PRSI dependencies on PAY_IE_PRSI

Line 1: PACKAGE BODY pay_ie_prsi AS

1: PACKAGE BODY pay_ie_prsi AS
2: /* $Header: pyieprsi.pkb 120.1 2006/12/17 08:43:38 rbhardwa noship $ */
3: /*
4: **
5: ** Copyright (C) 1999 Oracle Corporation

Line 45: g_package varchar2(33) := 'pay_ie_prsi.';

41: 16-dec-2006 rbhardwa 3427614 Modified code to calculate correct insurable weeks
42: for jan and dec.
43: ------------------------------------------------------------------------------
44: */
45: g_package varchar2(33) := 'pay_ie_prsi.';
46:
47: Function get_prsi_details ( p_assignment_id in number
48: ,p_payroll_action_id in number
49: ,p_contribution_class out nocopy varchar2

Line 69: from pay_ie_prsi_details_v pipd

65: ,overridden_ins_weeks
66: ,community_flag
67: ,exemption_start_date
68: ,exemption_end_date
69: from pay_ie_prsi_details_v pipd
70: ,pay_payroll_actions ppa
71: where assignment_id = p_assignment_id
72: and ppa.payroll_action_id = p_payroll_action_id
73: and ppa.date_earned between pipd.effective_start_date and pipd.effective_end_date;

Line 242: end pay_ie_prsi;

238: CLOSE get_end_date;
239: RETURN l_period_end_date;
240: End get_period_end_date;
241: --
242: end pay_ie_prsi;