DBA Data[Home] [Help]

APPS.PAY_IE_P30LOCK dependencies on DUAL

Line 230: FROM dual;

226: hr_utility.set_location('Payroll_action_id ' || csr_rec.payroll_action_id,15);
227: hr_utility.set_location('-----------------------------------------',17);
228: SELECT pay_assignment_actions_s.NEXTVAL
229: INTO l_actid
230: FROM dual;
231: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,csr_rec.tax_unit_id);
232: hr_utility.set_location('created pay_ass_act ' || l_actid || ' to ' || pactid,20);
233: hr_nonrun_asact.insint(l_actid, csr_rec.assignment_action_id);
234: hr_utility.set_location('created interlocks ' || l_actid || ' to ' || csr_rec.assignment_action_id,20);

Line 320: FROM dual;

316: hr_utility.set_location('Payroll_action_id ' || csr_rec.payroll_action_id,15);
317: hr_utility.set_location('-----------------------------------------',17);
318: SELECT pay_assignment_actions_s.NEXTVAL
319: INTO l_actid
320: FROM dual;
321: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,csr_rec.tax_unit_id);
322: hr_utility.set_location('created pay_ass_act ' || l_actid || ' to ' || pactid,20);
323: hr_nonrun_asact.insint(l_actid, csr_rec.assignment_action_id);
324: hr_utility.set_location('created interlocks ' || l_actid || ' to ' || csr_rec.assignment_action_id,20);