APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on PAY_CA_EOY_RL2_S

Line 124: PAY_CA_EOY_RL2_S instead of

120: The function compare_archive_data was also modified
121: for the situation where either the original RL2 or
122: the amended RL2 have not been archived
123: 04-AUG-2006 YDEVI 115.30 RL2 archiver will used
124: PAY_CA_EOY_RL2_S instead of
125: PAY_CA_EOY_RL1_S. to generate
126: sequence number
127: 18-AUG-2006 meshah 115.31 5202869 For performance issue modified the
128: cursor c_eoy_qbin.Removed the table

Line 2058: select l_rl2_starting_slip_num + pay_ca_eoy_rl2_s.nextval - 1

2054: end if;
2055: hr_utility.trace('Starting Slip number: '||l_rl2_starting_slip_num);
2056: hr_utility.trace('Ending Slip number: '||l_rl2_ending_slip_num);
2057:
2058: select l_rl2_starting_slip_num + pay_ca_eoy_rl2_s.nextval - 1
2059: into l_rl2_curr_slip_number from dual;
2060: hr_utility.trace('l_rl2_curr_slip_number: '||l_rl2_curr_slip_number);
2061:
2062: if l_rl2_ending_slip_num is not NULL and l_rl2_curr_slip_number is not NULL