APPS.PAY_SA_ARCHIVE dependencies on DUAL

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

404:
405: EXCEPTION
406: WHEN OTHERS THEN
407: -- Return cursor that selects no rows
408: p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
409:
410: END RANGE_CODE;
411:
412:

Line 539: FROM dual;

535:
536: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id THEN
537: SELECT pay_assignment_actions_s.NEXTVAL
538: INTO l_actid
539: FROM dual;
540: --
541: g_index_assact := g_index_assact + 1;
542: g_lock_table(g_index_assact).archive_assact_id := l_actid; /* For Element archival */
543: