2698: for asgrec in csr_get_pri_asg (pactid, stperson, endperson, g_wsp_end_date, g_legal_entity_id )
2699: loop
2700: hr_utility.set_location('Entering asgrec',10);
2701: -- create an assignment action for the primary assignment
2702: select pay_assignment_actions_s.nextval
2703: into lockingactid
2704: from dual;
2705:
2706: -- Insert assignment into pay_assignment_actions
2702: select pay_assignment_actions_s.nextval
2703: into lockingactid
2704: from dual;
2705:
2706: -- Insert assignment into pay_assignment_actions
2707: hr_nonrun_asact.insact
2708: (
2709: lockingactid,
2710: asgrec.assignment_id,
2719: for asgrec in csr_get_pri_asg (pactid, stperson, endperson, g_wsp_end_date, rec_le_id.organization_id )
2720: loop
2721: hr_utility.set_location('Entering asgrec ',20);
2722: -- create an assignment action for the primary assignment
2723: select pay_assignment_actions_s.nextval
2724: into lockingactid
2725: from dual;
2726:
2727: -- Insert assignment into pay_assignment_actions
2723: select pay_assignment_actions_s.nextval
2724: into lockingactid
2725: from dual;
2726:
2727: -- Insert assignment into pay_assignment_actions
2728: hr_nonrun_asact.insact
2729: (
2730: lockingactid,
2731: asgrec.assignment_id,
4175: , l_disability
4176: , l_legal_entity_id
4177: , l_ass_cat_name
4178: From per_all_assignments_f paaf
4179: , pay_assignment_actions paa
4180: , per_all_people_f perf
4181: , per_assignment_extra_info paei
4182: Where paa.assignment_action_id = p_assactid
4183: and paa.assignment_id = paaf.assignment_id