eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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.9 2011/03/02 11:11:44 pnethaga ship $ */
3: --
4: -- Constants
5: --

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

2: /* $Header: pykryean.pkb 120.9 2011/03/02 11:11:44 pnethaga ship $ */
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 362: and pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,

358: where
359: information_type in ('KR_YEA_SEP_PEN_DETAILS','KR_YEA_PEN_SAVING_DETAILS','KR_YEA_HOU_SAVING_DETAILS','KR_YEA_LT_STOCK_SAVING_DETAILS')
360: and assignment_id = p_ass_id
361: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')
362: and pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,
363: p_effective_date, information_type,aei_information6) > 0;
364:
365:
366: begin

Line 488: end pay_kr_yea_magtape_fun_pkg;

484: return g_archive_item_value;
485:
486: end get_sep_pen_eligible;
487:
488: end pay_kr_yea_magtape_fun_pkg;