APPS.PAY_CA_PAYROLL_ARCH dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 1822: select pay_assignment_actions_s.nextval

1818: *******************************************************************/
1819:
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);

Line 2298: select pay_assignment_actions_s.nextval

2294:
2295: if ( ( ln_source_action_id <> prev_source_action_id ) or
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);

Line 2552: select pay_assignment_actions_s.nextval

2548:
2549: hr_utility.trace('MG ln_pp_asg_act_id : ' || ln_pp_asg_act_id);
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);

Line 2859: select pay_assignment_actions_s.nextval

2855: end if;
2856:
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);

Line 3858: select pay_assignment_actions_s.nextval

3854: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3855: hr_utility.trace('Action_type = '||lv_action_type );
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.