APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on DUAL

Line 277: individual reports where they are different from the

273: p_jurisdiction_context - Should the JURISDICTION_CODE context be set up
274: for the testing of the balance.
275:
276: Notes : This routine provides a way of coding explicit rules for
277: individual reports where they are different from the
278: standard selection criteria for the report type ie. in
279: NY state the selection of people in the 4th quarter is
280: different from the first 3.
281: */

Line 348: from dual

344: l_flag varchar2(1);
345:
346: cursor c_chk_footnote is
347: select 'Y'
348: from dual
349: where exists (select 'X'
350: from fnd_lookup_values
351: where ((lookup_type = 'PAY_CA_RL2_FOOTNOTES'
352: and lookup_code = p_footnote_code)

Line 1200: from dual;

1196: combination. */
1197:
1198: select pay_assignment_actions_s.nextval
1199: into lockingactid
1200: from dual;
1201:
1202: /* Insert into pay_assignment_actions. */
1203:
1204: hr_utility.trace('creating assignment_action');

Line 2221: into l_rl2_curr_slip_number from dual;

2217:
2218: hr_utility.trace('l_rl2_last_slip_number b4 adding sequence= '|| l_rl2_last_slip_number);
2219:
2220: select l_rl2_last_slip_number + pay_ca_eoy_rl2_s.nextval - 1
2221: into l_rl2_curr_slip_number from dual;
2222:
2223: hr_utility.trace('1');
2224:
2225: l_rl2_slip_number_last_digit := mod(l_rl2_curr_slip_number,7);