271: --
272: FOR l_asg in csr_asg LOOP
273: hr_utility.set_location('Entering: ' || c_proc, 20);
274: --
275: SELECT pay_assignment_actions_s.nextval
276: INTO l_locking_action_id
277: FROM dual;
278: --
279: hr_nonrun_asact.insact(
673: -- at the same time.
674: --
675: select asg.assignment_id
676: into l_assignment_id
677: from pay_assignment_actions paa,
678: per_all_assignments_f asg
679: where paa.assignment_action_id = p_assignment_action_id
680: and asg.assignment_id = paa.assignment_id
681: and asg.effective_start_date <= g_effective_date
1226: and action_context_type = 'PA');
1227: --
1228: cursor csr_assacts is
1229: select paa.assignment_action_id
1230: from pay_assignment_actions paa
1231: where paa.payroll_action_id = p_payroll_action_id
1232: and paa.action_status = 'C'
1233: and not exists(
1234: select null