APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 2708: select pay_assignment_actions_s.nextval

2704: for asgrec in csr_get_pri_asg (pactid, stperson, endperson, g_wsp_end_date, g_legal_entity_id )
2705: loop
2706: hr_utility.set_location('Entering asgrec',10);
2707: -- create an assignment action for the primary assignment
2708: select pay_assignment_actions_s.nextval
2709: into lockingactid
2710: from dual;
2711:
2712: -- Insert assignment into pay_assignment_actions

Line 2712: -- Insert assignment into pay_assignment_actions

2708: select pay_assignment_actions_s.nextval
2709: into lockingactid
2710: from dual;
2711:
2712: -- Insert assignment into pay_assignment_actions
2713: hr_nonrun_asact.insact
2714: (
2715: lockingactid,
2716: asgrec.assignment_id,

Line 2729: select pay_assignment_actions_s.nextval

2725: for asgrec in csr_get_pri_asg (pactid, stperson, endperson, g_wsp_end_date, rec_le_id.organization_id )
2726: loop
2727: hr_utility.set_location('Entering asgrec ',20);
2728: -- create an assignment action for the primary assignment
2729: select pay_assignment_actions_s.nextval
2730: into lockingactid
2731: from dual;
2732:
2733: -- Insert assignment into pay_assignment_actions

Line 2733: -- Insert assignment into pay_assignment_actions

2729: select pay_assignment_actions_s.nextval
2730: into lockingactid
2731: from dual;
2732:
2733: -- Insert assignment into pay_assignment_actions
2734: hr_nonrun_asact.insact
2735: (
2736: lockingactid,
2737: asgrec.assignment_id,

Line 4185: , pay_assignment_actions paa

4181: , l_disability
4182: , l_legal_entity_id
4183: , l_ass_cat_name
4184: From per_all_assignments_f paaf
4185: , pay_assignment_actions paa
4186: , per_all_people_f perf
4187: , per_assignment_extra_info paei
4188: Where paa.assignment_action_id = p_assactid
4189: and paa.assignment_id = paaf.assignment_id