APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on DUAL

Line 316: individual reports where they are different from the

312: p_jurisdiction_context - Should the JURISDICTION_CODE context be set up
313: for the testing of the balance.
314:
315: Notes : This routine provides a way of coding explicit rules for
316: individual reports where they are different from the
317: standard selection criteria for the report type ie. in
318: NY state the selection of people in the 4th quarter is
319: different from the first 3.
320: */

Line 387: from dual

383: l_flag varchar2(1);
384:
385: cursor c_chk_footnote is
386: select 'Y'
387: from dual
388: where exists (select 'X'
389: from fnd_lookup_values
390: where ((lookup_type = 'PAY_CA_RL2_FOOTNOTES'
391: and lookup_code = p_footnote_code)

Line 1361: from dual;

1357: combination. */
1358:
1359: select pay_assignment_actions_s.nextval
1360: into lockingactid
1361: from dual;
1362:
1363: /* Insert into pay_assignment_actions. */
1364:
1365: hr_utility.trace('creating assignment_action');

Line 1995: from dual;

1991: if (l_start_seq_num is not null) then
1992: hr_utility.trace('In pay_ca_eoy_rl2_archive.gen_rl2_pdf_seq 30');
1993:
1994: select PAY_CA_RL2_PDF_SEQ_COUNT_S.nextval into l_seq_offset
1995: from dual;
1996: l_final_seq_num := getnext_seq_num(l_start_seq_num + l_seq_offset); --Bug 8500723
1997: elsif (called_from ='ARCHIVER') then
1998: l_final_seq_num := null;
1999: end if;

Line 2059: into l_rl2_curr_slip_number from dual;

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
2063: and l_rl2_curr_slip_number > l_rl2_ending_slip_num then