APPS.PAY_FI_PAYLIST_ARCHIVE dependencies on DUAL

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

345: WHEN OTHERS
346: THEN
347: -- Return cursor that selects no rows
348: p_sql :=
349: 'select 1 from dual where to_char(:payroll_action_id) = dummy';
350: END range_code;
351:
352: /* ASSIGNMENT ACTION CODE */
353: PROCEDURE assignment_action_code (

Line 500: FROM DUAL;

496: -- rec_prepaid_assignments.prepaid_action_id
497: THEN
498: SELECT pay_assignment_actions_s.NEXTVAL
499: INTO l_actid
500: FROM DUAL;
501:
502: --
503: g_index_assact := g_index_assact
504: + 1;