APPS.PAY_FI_ARCHIVE_PYSA dependencies on DUAL

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

341: END IF;
342: EXCEPTION
343: WHEN OTHERS THEN
344: -- Return cursor that selects no rows
345: p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
346: END RANGE_CODE;
347: /* ASSIGNMENT ACTION CODE */
348: PROCEDURE ASSIGNMENT_ACTION_CODE
349: (p_payroll_action_id IN NUMBER

Line 459: FROM dual;

455: ,l_canonical_end_date) LOOP
456: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id THEN
457: SELECT pay_assignment_actions_s.NEXTVAL
458: INTO l_actid
459: FROM dual;
460: --
461: g_index_assact := g_index_assact + 1;
462: g_lock_table(g_index_assact).archive_assact_id := l_actid; /* For Element archival */
463: -- Create the archive assignment action