DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on PAY_CA_RL1_PDF_SEQ_COUNT_S

Line 2266: select PAY_CA_RL1_PDF_SEQ_COUNT_S.nextval into l_seq_offset

2262: hr_utility.trace('In pay_ca_eoy_rl1_archive.gen_rl1_pdf_seq 30');
2263: hr_utility.trace('l_start_seq_num = '||l_start_seq_num);
2264: hr_utility.trace('l_end_seq_num = '||l_end_seq_num);
2265:
2266: select PAY_CA_RL1_PDF_SEQ_COUNT_S.nextval into l_seq_offset
2267: from dual;
2268: l_final_seq_num := getnext_seq_num(l_start_seq_num + l_seq_offset);
2269:
2270: hr_utility.trace('l_seq_offset = '||l_seq_offset);