APPS.PAY_CA_EOY_ARCHIVE dependencies on DUAL

Line 422: individual reports where they are different from the

418: p_jurisdiction_context - Should the JURISDICTION_CODE context be set up
419: for the testing of the balance.
420:
421: Notes : This routine provides a way of coding explicit rules for
422: individual reports where they are different from the
423: standard selection criteria for the report type ie. in
424: NY state the selection of people in the 4th quarter is
425: different from the first 3.
426: */

Line 926: from dual;

922: /* Create the assignment action to archive T4 details */
923:
924: select pay_assignment_actions_s.nextval
925: into lockingactid
926: from dual;
927:
928: /* Insert into pay_assignment_actions. */
929:
930: hr_utility.trace('creating assignment action');

Line 1808: from dual

1804: l_flag varchar2(1);
1805:
1806: cursor c_chk_payroll_action is
1807: select 'Y'
1808: from dual
1809: where exists (select null
1810: from ff_archive_items fai
1811: where fai.context1 = p_payroll_action_id
1812: and archive_type = 'PA');