185: for l_asg in csr_asg(g_pact.payroll_id)
186: loop
187: select pay_assignment_actions_s.nextval
188: into l_locking_action_id
189: from dual;
190: --
191: open csr_bal_asg(g_pact.bal_adj_action_id, l_asg.assignment_id);
192: fetch csr_bal_asg into l_locked_action_id, l_tax_unit_id;
193: close csr_bal_asg;
311: --
312: for l_asg in csr_asg(g_pact.payroll_id) loop
313: select pay_assignment_actions_s.nextval
314: into l_locking_action_id
315: from dual;
316: --
317: open csr_bal_asg(g_pact.bal_adj_action_id, l_asg.assignment_id);
318: fetch csr_bal_asg into l_locked_action_id, l_tax_unit_id;
319: close csr_bal_asg;