APPS.PAY_SA_ARCHIVE dependencies on DUAL

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

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

Line 538: FROM dual;

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