DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MAGTAPE_FUN_PKG dependencies on PAY_KR_YEA_MAGTAPE_FUN_PKG

Line 1: package body pay_kr_yea_magtape_fun_pkg as

1: package body pay_kr_yea_magtape_fun_pkg as
2: /* $Header: pykryean.pkb 120.2.12000000.3 2007/02/14 13:24:02 vaisriva noship $ */
3: --
4: -- Constants
5: --

Line 6: c_package constant varchar2(31) := ' pay_kr_yea_magtape_fun_pkg.';

2: /* $Header: pykryean.pkb 120.2.12000000.3 2007/02/14 13:24:02 vaisriva noship $ */
3: --
4: -- Constants
5: --
6: c_package constant varchar2(31) := ' pay_kr_yea_magtape_fun_pkg.';
7: --
8: ------------------------------------------------------------------------
9: procedure invalid_argument(
10: p_procedure in varchar2,

Line 52: and ((pay_kr_yea_magtape_pkg.g_re_yea <> 'R') or (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, pay_kr_yea_magtape_pkg.g_payroll_action_id, pay_kr_yea_magtape_pkg.g_target_year) = 'Y'))

48: and paa.payroll_action_id = ppa.payroll_action_id
49: and ppa.payroll_action_id = ppa.payroll_action_id
50: -- Bug 3248513
51: and ((pay_kr_yea_magtape_pkg.g_assignment_set_id is null) or (hr_assignment_set.assignment_in_set(pay_kr_yea_magtape_pkg.g_assignment_set_id, paa.assignment_id) = 'Y'))
52: and ((pay_kr_yea_magtape_pkg.g_re_yea <> 'R') or (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, pay_kr_yea_magtape_pkg.g_payroll_action_id, pay_kr_yea_magtape_pkg.g_target_year) = 'Y'))
53: --
54: and paa.tax_unit_id = bp.organization_id
55: and paa.action_status = 'C';
56:

Line 82: and ((pay_kr_yea_magtape_pkg.g_re_yea <> 'R') or (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, pay_kr_yea_magtape_pkg.g_payroll_action_id, pay_kr_yea_magtape_pkg.g_target_year) = 'Y'))

78: and paa.payroll_action_id = ppa.payroll_action_id
79: and ppa.payroll_action_id = ppa.payroll_action_id
80: -- Bug 3248513
81: and ((pay_kr_yea_magtape_pkg.g_assignment_set_id is null) or (hr_assignment_set.assignment_in_set(pay_kr_yea_magtape_pkg.g_assignment_set_id, paa.assignment_id) = 'Y'))
82: and ((pay_kr_yea_magtape_pkg.g_re_yea <> 'R') or (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, pay_kr_yea_magtape_pkg.g_payroll_action_id, pay_kr_yea_magtape_pkg.g_target_year) = 'Y'))
83: --
84: and paa.tax_unit_id = bp.organization_id
85: and paa.action_status = 'C'
86: and i1.context1(+) = paa.assignment_action_id

Line 115: and ((pay_kr_yea_magtape_pkg.g_re_yea <> 'R') or (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, pay_kr_yea_magtape_pkg.g_payroll_action_id, pay_kr_yea_magtape_pkg.g_target_year) = 'Y'))

111: and paa.payroll_action_id = ppa.payroll_action_id
112: and ppa.payroll_action_id = ppa.payroll_action_id
113: -- Bug 3248513
114: and ((pay_kr_yea_magtape_pkg.g_assignment_set_id is null) or (hr_assignment_set.assignment_in_set(pay_kr_yea_magtape_pkg.g_assignment_set_id, paa.assignment_id) = 'Y'))
115: and ((pay_kr_yea_magtape_pkg.g_re_yea <> 'R') or (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, pay_kr_yea_magtape_pkg.g_payroll_action_id, pay_kr_yea_magtape_pkg.g_target_year) = 'Y'))
116: --
117: and paa.tax_unit_id = bp.organization_id
118: and paa.action_status = 'C'
119: and aei.assignment_id = paa.assignment_id

Line 311: end pay_kr_yea_magtape_fun_pkg;

307: return l_count+1; -- Bug 5654127: Added 1 for the employee details record
308:
309: end e_record_count;
310: ---------------------------------------------------------------------------
311: end pay_kr_yea_magtape_fun_pkg;