234: g_employee_id,
235: g_assignment_set_id)
236: LOOP
237:
238: SELECT pay_assignment_actions_s.NEXTVAL
239: INTO l_actid
240: FROM DUAL;
241:
242: hr_nonrun_asact.insact (l_actid,
321: past.per_system_status
322: FROM per_all_people_f papf,
323: per_all_assignments_f paaf,
324: per_assignment_status_types past,
325: pay_assignment_actions paas,
326: hr_soft_coding_keyflex hsc,
327: hr_organization_information hoi
328: WHERE paas.assignment_action_id = p_assignment_action_id
329: AND papf.person_id = nvl(csr_v_person_id,papf.person_id)