DBA Data[Home] [Help]

APPS.PAY_IE_P30LOCK dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 222: SELECT pay_assignment_actions_s.NEXTVAL

218: hr_utility.set_location('Assignment_action_id ' || csr_rec.assignment_action_id,14);
219: hr_utility.set_location('pactid_id ' || pactid,15);
220: hr_utility.set_location('Payroll_action_id ' || csr_rec.payroll_action_id,15);
221: hr_utility.set_location('-----------------------------------------',17);
222: SELECT pay_assignment_actions_s.NEXTVAL
223: INTO l_actid
224: FROM dual;
225: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,csr_rec.tax_unit_id);
226: hr_utility.set_location('created pay_ass_act ' || l_actid || ' to ' || pactid,20);

Line 312: SELECT pay_assignment_actions_s.NEXTVAL

308: hr_utility.set_location('Assignment_action_id ' || csr_rec.assignment_action_id,14);
309: hr_utility.set_location('Pact_id ' || pactid,15);
310: hr_utility.set_location('Payroll_action_id ' || csr_rec.payroll_action_id,15);
311: hr_utility.set_location('-----------------------------------------',17);
312: SELECT pay_assignment_actions_s.NEXTVAL
313: INTO l_actid
314: FROM dual;
315: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,csr_rec.tax_unit_id);
316: hr_utility.set_location('created pay_ass_act ' || l_actid || ' to ' || pactid,20);