DBA Data[Home] [Help]

APPS.PAY_IE_P30LOCK dependencies on DUAL

Line 224: FROM dual;

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);
227: hr_nonrun_asact.insint(l_actid, csr_rec.assignment_action_id);
228: hr_utility.set_location('created interlocks ' || l_actid || ' to ' || csr_rec.assignment_action_id,20);

Line 314: FROM dual;

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);
317: hr_nonrun_asact.insint(l_actid, csr_rec.assignment_action_id);
318: hr_utility.set_location('created interlocks ' || l_actid || ' to ' || csr_rec.assignment_action_id,20);