APPS.PAY_CA_T4AEOY_ARCHIVE dependencies on DUAL

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

360: ** p_jurisdiction_context - Should the JURISDICTION_CODE context be set up
361: ** for the testing of the balance.
362: **
363: ** Notes : This routine provides a way of coding explicit rules for
364: ** individual reports where they are different from the
365: ** standard selection criteria for the report type ie. in
366: ** NY state the selection of people in the 4th quarter is
367: ** different from the first 3.
368: */

Line 775: from dual;

771: combination. */
772:
773: select pay_assignment_actions_s.nextval
774: into lockingactid
775: from dual;
776:
777: /* Insert into pay_assignment_actions. */
778:
779: hr_utility.trace('creating assignment action');

Line 1619: from dual

1615: l_flag varchar2(1);
1616:
1617: cursor c_chk_payroll_action is
1618: select 'Y'
1619: from dual
1620: where exists (select null
1621: from ff_archive_items fai
1622: where fai.context1 = p_payroll_action_id
1623: and archive_type = 'PA');