APPS.PAY_US_W2C_RPT dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 361: ln_serial_number pay_assignment_actions.serial_number%TYPE;

357: lv_record_name varchar2(50);
358: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
359: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
360: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;
361: ln_serial_number pay_assignment_actions.serial_number%TYPE;
362:
363: CURSOR c_selected_asg_set(cp_start_person in number
364: ,cp_end_person in number
365: ,cp_asg_set in number) is

Line 519: select pay_assignment_actions_s.nextval

515:
516: if get_prev_w2c_dtls%found then
517: if lv_report_type in ('W2C_PRE_PROCESS') then
518: /* Create an assignment action for this person */
519: select pay_assignment_actions_s.nextval
520: into ln_w2c_asg_action
521: from dual;
522: hr_utility.trace('New w2c Action = ' || ln_w2c_asg_action);
523:

Line 614: select pay_assignment_actions_s.nextval

610: exit;
611: end if;
612:
613: /* Create an assignment action for this person */
614: select pay_assignment_actions_s.nextval
615: into ln_w2c_asg_action
616: from dual;
617: hr_utility.trace('New w2c Action = ' || ln_w2c_asg_action);
618: