APPS.PAY_JP_DEF_REPORT_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 307: pay_assignment_actions paa,

303: pjda.assignment_action_id,
304: pjda.effective_date
305: from per_periods_of_service ppos,
306: per_all_assignments_f pa,
307: pay_assignment_actions paa,
308: pay_jp_def_assact_v pjda,
309: pay_jp_def_emp_v pjde
310: where ppos.person_id
311: between p_start_person_id and p_end_person_id

Line 335: pay_assignment_actions paa,

331: pjda.effective_date,
332: hasa.include_or_exclude
333: from per_periods_of_service ppos,
334: per_all_assignments_f pa,
335: pay_assignment_actions paa,
336: hr_assignment_set_amendments hasa,
337: pay_jp_def_assact_v pjda,
338: pay_jp_def_emp_v pjde
339: where ppos.person_id

Line 419: select pay_assignment_actions_s.nextval

415: and g_detail_debug = 'Y' then
416: hr_utility.set_location(l_proc,30);
417: end if;
418: --
419: select pay_assignment_actions_s.nextval
420: into l_assignment_action_id
421: from dual;
422: --
423: hr_nonrun_asact.insact(

Line 472: select pay_assignment_actions_s.nextval

468: and g_detail_debug = 'Y' then
469: hr_utility.set_location(l_proc,50);
470: end if;
471: --
472: select pay_assignment_actions_s.nextval
473: into l_assignment_action_id
474: from dual;
475: --
476: hr_nonrun_asact.insact(

Line 808: from pay_assignment_actions paa,

804: pjde.widow_details,
805: pjde.working_student_details,
806: pjde.change_date,
807: pjde.change_reason
808: from pay_assignment_actions paa,
809: pay_jp_def_pact_v pjdp,
810: pay_jp_def_assact_v pjda,
811: pay_jp_def_emp_v pjde
812: where paa.assignment_action_id = p_assignment_action_id

Line 2624: from pay_assignment_actions proc_paa

2620: --
2621: cursor csr_proc_assact
2622: is
2623: select source_action_id
2624: from pay_assignment_actions proc_paa
2625: where assignment_action_id = l_mag_assignment_action_id;
2626: --
2627: begin
2628: --

Line 2711: from pay_assignment_actions

2707: --
2708: cursor csr_action
2709: is
2710: select payroll_action_id
2711: from pay_assignment_actions
2712: where assignment_action_id = p_assignment_action_id;
2713: --
2714: begin
2715: --

Line 2888: -- pay_assignment_actions paa,

2884: ----
2885: -- p_sqlstr :=
2886: -- 'select paa.rowid
2887: -- from pay_payroll_actions ppa,
2888: -- pay_assignment_actions paa,
2889: -- pay_jp_def_assact_v pjda,
2890: -- pay_jp_def_emp_v pjde
2891: -- where ppa.payroll_action_id = :pactid
2892: -- and paa.payroll_action_id = ppa.payroll_action_id