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.2 2009/05/06 05:09:27 knadhan ship $ */
3: /*
4: **
5: ** Copyright (C) 1999 Oracle Corporation

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

43: ** 21-APR-2009 knadhan 8448176 Added function get_bal_value_30_04_09
44: ** 21-APR-2009 knadhan 8448176 Added exception block in function get_bal_value_30_04_09
45: ------------------------------------------------------------------------------
46: */
47: g_package varchar2(33) := 'pay_ie_prsi.';
48:
49: /* knadhan */
50: FUNCTION get_bal_value_30_04_09 (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
51: ,p_tax_unit_id IN NUMBER

Line 128: from pay_ie_prsi_details_v pipd

124: ,overridden_ins_weeks
125: ,community_flag
126: ,exemption_start_date
127: ,exemption_end_date
128: from pay_ie_prsi_details_v pipd
129: ,pay_payroll_actions ppa
130: where assignment_id = p_assignment_id
131: and ppa.payroll_action_id = p_payroll_action_id
132: and ppa.date_earned between pipd.effective_start_date and pipd.effective_end_date;

Line 301: end pay_ie_prsi;

297: CLOSE get_end_date;
298: RETURN l_period_end_date;
299: End get_period_end_date;
300: --
301: end pay_ie_prsi;