APPS.PAY_CA_T4AEOY_ARCHIVE dependencies on DUAL

Line 442: ** individual reports where they are different from the

438: ** p_jurisdiction_context - Should the JURISDICTION_CODE context be set up
439: ** for the testing of the balance.
440: **
441: ** Notes : This routine provides a way of coding explicit rules for
442: ** individual reports where they are different from the
443: ** standard selection criteria for the report type ie. in
444: ** NY state the selection of people in the 4th quarter is
445: ** different from the first 3.
446: */

Line 944: from dual;

940: combination. */
941:
942: select pay_assignment_actions_s.nextval
943: into lockingactid
944: from dual;
945:
946: /* Insert into pay_assignment_actions. */
947:
948: hr_utility.trace('creating assignment action');

Line 1818: from dual

1814: l_flag varchar2(1);
1815:
1816: cursor c_chk_payroll_action is
1817: select 'Y'
1818: from dual
1819: where exists (select null
1820: from ff_archive_items fai
1821: where fai.context1 = p_payroll_action_id
1822: and archive_type = 'PA');