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(
659: -- at the same time.
660: --
661: select asg.assignment_id
662: into l_assignment_id
663: from pay_assignment_actions paa,
664: per_all_assignments_f asg
665: where paa.assignment_action_id = p_assignment_action_id
666: and asg.assignment_id = paa.assignment_id
667: and asg.effective_start_date <= g_effective_date
1131: and action_context_type = 'PA');
1132: --
1133: cursor csr_assacts is
1134: select paa.assignment_action_id
1135: from pay_assignment_actions paa
1136: where paa.payroll_action_id = p_payroll_action_id
1137: and paa.action_status = 'C'
1138: and not exists(
1139: select null