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_DEF_SS dependencies on PAY_JP_DEF_ASSACT_V

Line 249: pay_jp_def_assact_v assact

245: submission_start_date,
246: submission_end_date
247: from pay_jp_def_pact_v pact,
248: pay_assignment_actions paa,
249: pay_jp_def_assact_v assact
250: where assact.action_information_id = p_action_information_id
251: and paa.assignment_action_id = assact.assignment_action_id
252: and pact.payroll_action_id = paa.payroll_action_id;
253: l_pact_rec csr_pact%rowtype;

Line 1441: p_rec out nocopy pay_jp_def_assact_v%rowtype)

1437: procedure lock_assact(
1438: p_action_information_id in number,
1439: p_object_version_number in number,
1440: p_business_group_id in out nocopy number,
1441: p_rec out nocopy pay_jp_def_assact_v%rowtype)
1442: is
1443: --
1444: cursor csr_bg
1445: is

Line 1456: from pay_jp_def_assact_v

1452: begin
1453: --
1454: select *
1455: into p_rec
1456: from pay_jp_def_assact_v
1457: where action_information_id = p_action_information_id
1458: for update nowait;
1459: --
1460: if p_rec.object_version_number <> p_object_version_number then

Line 2296: l_assact_rec pay_jp_def_assact_v%rowtype;

2292: p_object_version_number in out nocopy number)
2293: is
2294: --
2295: c_proc constant varchar2(61) := c_package || 'do_new';
2296: l_assact_rec pay_jp_def_assact_v%rowtype;
2297: --
2298: begin
2299: --
2300: hr_utility.set_location('Entering : ' || c_proc, 10);

Line 2375: l_assact_rec pay_jp_def_assact_v%rowtype;

2371: --
2372: l_business_group_id number;
2373: --
2374: l_submission_date date;
2375: l_assact_rec pay_jp_def_assact_v%rowtype;
2376: l_entry_rec pay_jp_def_entry_v%rowtype;
2377: l_entry_dep_rec pay_jp_def_entry_dep_v%rowtype;
2378: l_entry_os_rec pay_jp_def_entry_os_v%rowtype;
2379: l_emp_rec pay_jp_def_emp_v%rowtype;

Line 2634: l_assact_rec pay_jp_def_assact_v%rowtype;

2630: c_proc constant varchar2(61) := c_package || 'do_reject';
2631: --
2632: l_business_group_id number;
2633: --
2634: l_assact_rec pay_jp_def_assact_v%rowtype;
2635: begin
2636: hr_utility.set_location('Entering : ' || c_proc, 10);
2637: --
2638: lock_assact(p_action_information_id, p_object_version_number, l_business_group_id, l_assact_rec);

Line 2716: l_assact_rec pay_jp_def_assact_v%rowtype;

2712: c_proc constant varchar2(61) := c_package || 'do_return';
2713: --
2714: l_business_group_id number;
2715: --
2716: l_assact_rec pay_jp_def_assact_v%rowtype;
2717: begin
2718: hr_utility.set_location('Entering : ' || c_proc, 10);
2719: --
2720: lock_assact(p_action_information_id, p_object_version_number, l_business_group_id, l_assact_rec);

Line 2791: l_assact_rec pay_jp_def_assact_v%rowtype;

2787: c_proc constant varchar2(61) := c_package || 'do_approve';
2788: --
2789: l_business_group_id number;
2790: --
2791: l_assact_rec pay_jp_def_assact_v%rowtype;
2792: begin
2793: hr_utility.set_location('Entering : ' || c_proc, 10);
2794: --
2795: lock_assact(p_action_information_id, p_object_version_number, l_business_group_id, l_assact_rec);

Line 2856: from pay_jp_def_assact_v aif,

2852: l_payroll_action_id number := fnd_number.canonical_to_number(p_payroll_action_id);
2853: cursor csr_assact is
2854: select aif.action_information_id,
2855: aif.object_version_number
2856: from pay_jp_def_assact_v aif,
2857: pay_assignment_actions paa
2858: where paa.payroll_action_id = l_payroll_action_id
2859: and paa.action_status = 'C'
2860: and aif.assignment_action_id = paa.assignment_action_id

Line 2894: l_assact_rec pay_jp_def_assact_v%rowtype;

2890: is
2891: --
2892: c_proc constant varchar2(61) := c_package || 'do_transfer';
2893: --
2894: l_assact_rec pay_jp_def_assact_v%rowtype;
2895: l_entry_rec pay_jp_def_entry_v%rowtype;
2896: l_entry_dep_rec pay_jp_def_entry_dep_v%rowtype;
2897: l_dep_rec pay_jp_def_dep_v%rowtype;
2898: l_dep_oe_rec pay_jp_def_dep_oe_v%rowtype;

Line 3180: pay_jp_def_assact_v assact,

3176: per.full_name,
3177: asg.assignment_number
3178: from per_all_people_f per,
3179: per_all_assignments_f asg,
3180: pay_jp_def_assact_v assact,
3181: pay_assignment_actions paa
3182: where paa.payroll_action_id = l_payroll_action_id
3183: and paa.action_status = 'C'
3184: and assact.assignment_action_id = paa.assignment_action_id

Line 3249: l_assact_rec pay_jp_def_assact_v%rowtype;

3245: is
3246: --
3247: c_proc constant varchar2(61) := c_package ||'rollback_transfer';
3248: --
3249: l_assact_rec pay_jp_def_assact_v%rowtype;
3250: l_entry_rec pay_jp_def_entry_v%rowtype;
3251: l_entry_dep_rec pay_jp_def_entry_dep_v%rowtype;
3252: l_entry_os_rec pay_jp_def_entry_os_v%rowtype;
3253: l_dep_rec pay_jp_def_dep_v%rowtype;

Line 3530: l_assact_rec pay_jp_def_assact_v%rowtype;

3526: c_proc constant varchar2(61) := c_package ||'do_expire';
3527: --
3528: l_business_group_id number;
3529: --
3530: l_assact_rec pay_jp_def_assact_v%rowtype;
3531: l_year_end_date date;
3532: l_esd date;
3533: l_eed date;
3534: l_warning boolean;

Line 3797: l_assact_rec pay_jp_def_assact_v%rowtype;

3793: c_proc constant varchar2(61) := c_package ||'rollback_expire';
3794: --
3795: l_business_group_id number;
3796: --
3797: l_assact_rec pay_jp_def_assact_v%rowtype;
3798: l_esd date;
3799: l_eed date;
3800: l_warning boolean;
3801: --

Line 4057: from pay_jp_def_assact_v aif,

4053: is
4054: l_payroll_action_id number := fnd_number.canonical_to_number(p_payroll_action_id);
4055: cursor csr_assact is
4056: select paa.assignment_action_id
4057: from pay_jp_def_assact_v aif,
4058: pay_assignment_actions paa
4059: where paa.payroll_action_id = l_payroll_action_id
4060: and aif.assignment_action_id(+) = paa.assignment_action_id
4061: and nvl(aif.transaction_status, 'U') not in ('F', 'A');