DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on PAY_CA_EOY_RL1_S

Line 2395: /*select l_rl1_last_slip_number + pay_ca_eoy_rl1_s.nextval - 1

2391:
2392: hr_utility.trace('2');
2393:
2394: -- Added for bug 11694701
2395: /*select l_rl1_last_slip_number + pay_ca_eoy_rl1_s.nextval - 1
2396: into l_rl1_curr_slip_number from dual;*/
2397: select l_rl1_starting_slip_num + pay_ca_eoy_rl1_s.nextval - 1
2398: into l_rl1_curr_slip_number from dual;
2399: hr_utility.trace('l_rl1_curr_slip_number: '||l_rl1_curr_slip_number);

Line 2397: select l_rl1_starting_slip_num + pay_ca_eoy_rl1_s.nextval - 1

2393:
2394: -- Added for bug 11694701
2395: /*select l_rl1_last_slip_number + pay_ca_eoy_rl1_s.nextval - 1
2396: into l_rl1_curr_slip_number from dual;*/
2397: select l_rl1_starting_slip_num + pay_ca_eoy_rl1_s.nextval - 1
2398: into l_rl1_curr_slip_number from dual;
2399: hr_utility.trace('l_rl1_curr_slip_number: '||l_rl1_curr_slip_number);
2400:
2401: if l_rl1_ending_slip_num is not NULL and l_rl1_curr_slip_number is not NULL