DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL1_CANCELLED_PKG dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 404: ln_serial_number pay_assignment_actions.serial_number%TYPE;

400: lv_record_name varchar2(100);
401: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
402: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
403: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;
404: ln_serial_number pay_assignment_actions.serial_number%TYPE;
405: ln_pre_id NUMBER;
406: ln_pre_parameter NUMBER;
407: lv_ppr_report_type varchar2(50);
408:

Line 799: lv_serial_number pay_assignment_actions.serial_number%TYPE;

795: ln_yepp_pact_id number;
796: ln_pre_id_null number;
797: ln_iteration number :=0;
798: lv_flag_count number :=0;
799: lv_serial_number pay_assignment_actions.serial_number%TYPE;
800:
801:
802: lv_negative_bal_flag varchar2(10);
803: lv_neg_bal_mesg varchar2(100);

Line 948: select pay_assignment_actions_s.nextval

944: 'PRINT',
945: 'ASSIGNMENT',
946: ln_primary_assignment_id,
947: l_effective_end_date),'Y') = 'Y' then
948: select pay_assignment_actions_s.nextval
949: into ln_rl1_cancelled_asg_action
950: from dual;
951:
952: hr_utility.trace('New RL1 Amend Action = ' ||

Line 1097: select pay_assignment_actions_s.nextval

1093: 'PRINT',
1094: 'ASSIGNMENT',
1095: ln_primary_assignment_id,
1096: l_effective_end_date),'Y') = 'Y' then
1097: select pay_assignment_actions_s.nextval
1098: into ln_rl1_cancelled_asg_action
1099: from dual;
1100:
1101: hr_utility.trace('New RL1 Cancel Action = ' ||