APPS.PAY_KW_ARCHIVE dependencies on DUAL

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

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

Line 545: FROM dual;

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