APPS.PAY_IP_PAYROLL_ARCH dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 2491: lv_serial_number pay_assignment_actions.serial_number%TYPE;

2487: ld_prev_effective_date DATE;
2488:
2489: ln_xfr_action_id NUMBER;
2490:
2491: lv_serial_number pay_assignment_actions.serial_number%TYPE;
2492: lv_procedure_name VARCHAR2(100);
2493: lv_error_message VARCHAR2(200);
2494: ln_step NUMBER;
2495:

Line 2604: SELECT pay_assignment_actions_s.NEXTVAL

2600: ELSE
2601: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2602: hr_utility.trace('Action_type = '||lv_action_type );
2603:
2604: SELECT pay_assignment_actions_s.NEXTVAL
2605: INTO ln_xfr_action_id
2606: FROM dual;
2607:
2608: -- insert into pay_assignment_actions.

Line 4272: lv_xfr_master_serial_number pay_assignment_actions.serial_number%TYPE;

4268: ln_xfr_assignment_id NUMBER;
4269: ln_assignment_id NUMBER;
4270: ln_chunk_number NUMBER;
4271:
4272: lv_xfr_master_serial_number pay_assignment_actions.serial_number%TYPE;
4273: lv_master_action_type pay_payroll_actions.action_type%TYPE;
4274:
4275: lv_master_sepcheck_flag VARCHAR2(1);
4276: ln_asg_action_id NUMBER;

Line 4309: lv_serial_number pay_assignment_actions.serial_number%TYPE;

4305: ln_rqp_action_id NUMBER;
4306: ln_ppp_source_action_id NUMBER;
4307: ln_master_run_aa_id NUMBER;
4308: ln_earnings NUMBER;
4309: lv_serial_number pay_assignment_actions.serial_number%TYPE;
4310:
4311: ln_is_run_qp_found NUMBER;
4312: ln_all_run_asg_act_id NUMBER;
4313:

Line 4513: SELECT pay_assignment_actions_s.nextval

4509: FETCH c_get_prepay_aaid_for_sepchk INTO ln_asg_action_id;
4510: CLOSE c_get_prepay_aaid_for_sepchk;
4511:
4512: ln_step := 13;
4513: SELECT pay_assignment_actions_s.nextval
4514: INTO ln_child_xfr_action_id
4515: FROM dual;
4516:
4517: hr_utility.set_location(gv_package || lv_procedure_name, 70);