APPS.PAY_US_W2C_RPT dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 407: ln_serial_number pay_assignment_actions.serial_number%TYPE;

403: lv_record_name varchar2(50);
404: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
405: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
406: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;
407: ln_serial_number pay_assignment_actions.serial_number%TYPE;
408:
409: CURSOR c_selected_asg_set(cp_start_person in number
410: ,cp_end_person in number
411: ,cp_asg_set in number) is

Line 572: select pay_assignment_actions_s.nextval

568: if get_prev_w2c_dtls%found then
569:
570: if lv_report_type in ('W2C_PRE_PROCESS') then
571: /* Create an assignment action for this person */
572: select pay_assignment_actions_s.nextval
573: into ln_w2c_asg_action
574: from dual;
575: hr_utility.trace('New w2c Action = ' || ln_w2c_asg_action);
576:

Line 669: select pay_assignment_actions_s.nextval

665: exit;
666: end if;
667:
668: /* Create an assignment action for this person */
669: select pay_assignment_actions_s.nextval
670: into ln_w2c_asg_action
671: from dual;
672: hr_utility.trace('New w2c Action = ' || ln_w2c_asg_action);
673: