APPS.PAY_CA_PAYROLL_ARCH dependencies on DUAL

Line 1824: from dual;

1820: if ( ln_source_action_id <> prev_source_action_id ) then
1821:
1822: select pay_assignment_actions_s.nextval
1823: into ln_child_xfr_action_id
1824: from dual;
1825:
1826: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1827:
1828: -- insert into pay_assignment_actions.

Line 2300: from dual;

2296: ( ln_tax_unit_id <> prev_tax_unit_id ) ) then
2297:
2298: select pay_assignment_actions_s.nextval
2299: into ln_child_xfr_action_id
2300: from dual;
2301:
2302: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2303:
2304: -- insert into pay_assignment_actions.

Line 2554: from dual;

2550: hr_utility.trace('MG ln_tax_unit_id : ' || ln_tax_unit_id);
2551:
2552: select pay_assignment_actions_s.nextval
2553: into ln_child_xfr_action_id
2554: from dual;
2555:
2556: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2557:
2558: -- insert into pay_assignment_actions.

Line 2861: from dual;

2857: -- create child assignment action
2858: ln_step := 9;
2859: select pay_assignment_actions_s.nextval
2860: into ln_child_xfr_action_id
2861: from dual;
2862:
2863: hr_utility.set_location(gv_package || lv_procedure_name, 90);
2864: -- insert into pay_assignment_actions.
2865: ln_step := 10;

Line 3860: from dual;

3856:
3857: ln_step := 6;
3858: select pay_assignment_actions_s.nextval
3859: into ln_xfr_action_id
3860: from dual;
3861:
3862: -- insert into pay_assignment_actions.
3863: ln_step := 7;
3864: hr_nonrun_asact.insact(ln_xfr_action_id,