APPS.PAY_AE_ARCHIVE dependencies on DUAL

Line 416: p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';

412:
413: EXCEPTION
414: WHEN OTHERS THEN
415: -- Return cursor that selects no rows
416: p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
417:
418: END RANGE_CODE;
419:
420:

Line 547: FROM dual;

543:
544: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id THEN
545: SELECT pay_assignment_actions_s.NEXTVAL
546: INTO l_actid
547: FROM dual;
548: --
549: g_index_assact := g_index_assact + 1;
550: g_lock_table(g_index_assact).archive_assact_id := l_actid; /* For Element archival */
551: