APPS.PAY_CA_PAYROLL_ARCH dependencies on DUAL

Line 1322: from dual;

1318: if ( ln_source_action_id <> prev_source_action_id ) then
1319:
1320: select pay_assignment_actions_s.nextval
1321: into ln_child_xfr_action_id
1322: from dual;
1323:
1324: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1325:
1326: -- insert into pay_assignment_actions.

Line 1789: from dual;

1785: ( ln_tax_unit_id <> prev_tax_unit_id ) ) then
1786:
1787: select pay_assignment_actions_s.nextval
1788: into ln_child_xfr_action_id
1789: from dual;
1790:
1791: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1792:
1793: -- insert into pay_assignment_actions.

Line 2043: from dual;

2039: hr_utility.trace('MG ln_tax_unit_id : ' || ln_tax_unit_id);
2040:
2041: select pay_assignment_actions_s.nextval
2042: into ln_child_xfr_action_id
2043: from dual;
2044:
2045: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2046:
2047: -- insert into pay_assignment_actions.

Line 2350: from dual;

2346: -- create child assignment action
2347: ln_step := 9;
2348: select pay_assignment_actions_s.nextval
2349: into ln_child_xfr_action_id
2350: from dual;
2351:
2352: hr_utility.set_location(gv_package || lv_procedure_name, 90);
2353: -- insert into pay_assignment_actions.
2354: ln_step := 10;

Line 3349: from dual;

3345:
3346: ln_step := 6;
3347: select pay_assignment_actions_s.nextval
3348: into ln_xfr_action_id
3349: from dual;
3350:
3351: -- insert into pay_assignment_actions.
3352: ln_step := 7;
3353: hr_nonrun_asact.insact(ln_xfr_action_id,