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.

APPS.PAY_JP_ISDF_SS_PKG dependencies on PAY_JP_ISDF_ASSACT_V

Line 47: from pay_jp_isdf_assact_v assact,

43: select /*+ ORDERED */
44: pact.submission_period_status,
45: pact.submission_start_date,
46: pact.submission_end_date
47: from pay_jp_isdf_assact_v assact,
48: pay_assignment_actions paa,
49: pay_jp_isdf_pact_v pact
50: where assact.action_information_id = p_action_information_id
51: and paa.assignment_action_id = assact.assignment_action_id

Line 185: from pay_jp_isdf_assact_v pjia,

181: select /* +ORDERED */
182: ppa.payroll_action_id,
183: ppa.business_group_id,
184: ppa.effective_date
185: from pay_jp_isdf_assact_v pjia,
186: pay_assignment_actions paa,
187: pay_payroll_actions ppa
188: where pjia.action_information_id = p_action_information_id
189: and paa.assignment_action_id = pjia.assignment_action_id

Line 1074: l_assact_rec pay_jp_isdf_assact_v%rowtype;

1070: is
1071: --
1072: l_proc varchar2(80) := c_package||'do_new';
1073: l_submission_date date;
1074: l_assact_rec pay_jp_isdf_assact_v%rowtype;
1075: l_payroll_action_id number;
1076: --
1077: cursor csr_pact
1078: is

Line 1198: l_assact_rec pay_jp_isdf_assact_v%rowtype;

1194: p_object_version_number in out nocopy number)
1195: is
1196: l_proc varchar2(80) := c_package||'do_apply';
1197: l_submission_date date;
1198: l_assact_rec pay_jp_isdf_assact_v%rowtype;
1199: begin
1200: --
1201: if g_debug then
1202: hr_utility.set_location(l_proc,0);

Line 2536: l_assact_rec pay_jp_isdf_assact_v%rowtype;

2532: is
2533: --
2534: l_proc varchar2(80) := c_package||'do_calculate';
2535: l_submission_date date;
2536: l_assact_rec pay_jp_isdf_assact_v%rowtype;
2537: l_calc_dct_rec t_calc_dct_rec;
2538: l_action_information_id number;
2539: l_object_version_number number;
2540: --

Line 2568: from pay_jp_isdf_assact_v

2564: --
2565: -- unnecessary to lock
2566: select *
2567: into l_assact_rec
2568: from pay_jp_isdf_assact_v
2569: where action_information_id = p_action_information_id;
2570: --
2571: if l_assact_rec.transaction_status <> 'N' then
2572: fnd_message.set_name('PAY','PAY_JP_DEF_INVALID_TXN_STATUS');

Line 2689: l_assact_rec pay_jp_isdf_assact_v%rowtype;

2685: is
2686: --
2687: l_proc varchar2(80) := c_package||'do_finalize';
2688: l_submission_date date;
2689: l_assact_rec pay_jp_isdf_assact_v%rowtype;
2690: l_calc_dct_rec t_calc_dct_rec;
2691: l_action_information_id number;
2692: l_object_version_number number;
2693: --

Line 3001: l_assact_rec pay_jp_isdf_assact_v%rowtype;

2997: is
2998: --
2999: l_proc varchar2(80) := c_package||'do_finalize';
3000: l_submission_date date;
3001: l_assact_rec pay_jp_isdf_assact_v%rowtype;
3002: --
3003: begin
3004: --
3005: if g_debug then

Line 3088: l_assact_rec pay_jp_isdf_assact_v%rowtype;

3084: is
3085: --
3086: l_proc varchar2(80) := c_package||'do_return';
3087: l_submission_date date;
3088: l_assact_rec pay_jp_isdf_assact_v%rowtype;
3089: --
3090: begin
3091: --
3092: if g_debug then

Line 3167: l_assact_rec pay_jp_isdf_assact_v%rowtype;

3163: p_object_version_number in out nocopy number)
3164: is
3165: --
3166: l_proc varchar2(80) := c_package||'do_approve';
3167: l_assact_rec pay_jp_isdf_assact_v%rowtype;
3168: --
3169: begin
3170: --
3171: if g_debug then

Line 4379: l_assact_rec pay_jp_isdf_assact_v%rowtype;

4375: p_expire_after_transfer in varchar2 default 'N')
4376: is
4377: --
4378: l_proc varchar2(80) := c_package||'do_transfer';
4379: l_assact_rec pay_jp_isdf_assact_v%rowtype;
4380: l_effective_date date;
4381: l_year_end_date date;
4382: l_dec_first_date date;
4383: --

Line 4644: l_assact_rec pay_jp_isdf_assact_v%rowtype;

4640: -- ZAP : remove archive data of status D
4641: -- N/A : nothing to do. (original)
4642: --
4643: l_proc varchar2(80) := c_package||'do_expire';
4644: l_assact_rec pay_jp_isdf_assact_v%rowtype;
4645: l_effective_date date;
4646: l_dec_first_date date;
4647: l_year_end_date date;
4648: l_esd date;

Line 4878: pay_jp_isdf_assact_v assact,

4874: assact.object_version_number,
4875: pp.full_name,
4876: pa.assignment_number
4877: from pay_assignment_actions paa,
4878: pay_jp_isdf_assact_v assact,
4879: per_all_assignments_f pa,
4880: per_all_people_f pp
4881: where paa.payroll_action_id = p_payroll_action_id
4882: and paa.action_status = 'C'

Line 4963: pay_jp_isdf_assact_v assact,

4959: assact.object_version_number,
4960: pp.full_name,
4961: pa.assignment_number
4962: from pay_assignment_actions paa,
4963: pay_jp_isdf_assact_v assact,
4964: per_all_assignments_f pa,
4965: per_all_people_f pp
4966: where paa.payroll_action_id = p_payroll_action_id
4967: and paa.action_status = 'C'

Line 5049: pay_jp_isdf_assact_v assact,

5045: assact.object_version_number,
5046: pp.full_name,
5047: pa.assignment_number
5048: from pay_assignment_actions paa,
5049: pay_jp_isdf_assact_v assact,
5050: per_all_assignments_f pa,
5051: per_all_people_f pp
5052: where paa.payroll_action_id = p_payroll_action_id
5053: and paa.action_status = 'C'

Line 5143: pay_jp_isdf_assact_v assact,

5139: assact.object_version_number,
5140: pp.full_name,
5141: pa.assignment_number
5142: from pay_assignment_actions paa,
5143: pay_jp_isdf_assact_v assact,
5144: per_all_assignments_f pa,
5145: per_all_people_f pp
5146: where paa.payroll_action_id = p_payroll_action_id
5147: and paa.action_status = 'C'