APPS.PAY_CA_EOY_ARCHIVE dependencies on DUAL

Line 489: individual reports where they are different from the

485: p_jurisdiction_context - Should the JURISDICTION_CODE context be set up
486: for the testing of the balance.
487:
488: Notes : This routine provides a way of coding explicit rules for
489: individual reports where they are different from the
490: standard selection criteria for the report type ie. in
491: NY state the selection of people in the 4th quarter is
492: different from the first 3.
493: */

Line 1084: from dual;

1080: /* Create the assignment action to archive T4 details */
1081:
1082: select pay_assignment_actions_s.nextval
1083: into lockingactid
1084: from dual;
1085:
1086: /* Insert into pay_assignment_actions. */
1087:
1088: hr_utility.trace('creating assignment action');

Line 2026: from dual

2022: l_flag varchar2(1);
2023:
2024: cursor c_chk_payroll_action is
2025: select 'Y'
2026: from dual
2027: where exists (select null
2028: from ff_archive_items fai
2029: where fai.context1 = p_payroll_action_id
2030: and archive_type = 'PA');