APPS.PAY_FI_ARCHIVE_TEL dependencies on DUAL

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

619: EXCEPTION
620: WHEN OTHERS
621: THEN
622: -- Return cursor that selects no rows
623: p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
624: END RANGE_CODE;
625:
626:
627: /* ASSIGNMENT ACTION CODE */

Line 836: FROM dual;

832: fnd_file.put_line(fnd_file.log,' LU Inside the Csr Prepaid Cursor ');
833: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id THEN
834: SELECT pay_assignment_actions_s.NEXTVAL
835: INTO l_actid
836: FROM dual;
837: --
838: g_index_assact := g_index_assact + 1;
839: g_lock_table(g_index_assact).archive_assact_id := l_actid; /* For Element archival */
840: -- Create the archive assignment action

Line 869: FROM dual;

865: fnd_file.put_line(fnd_file.log,' LE Inside the Csr Prepaid Cursor ');
866: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id THEN
867: SELECT pay_assignment_actions_s.NEXTVAL
868: INTO l_actid
869: FROM dual;
870: --
871: g_index_assact := g_index_assact + 1;
872: g_lock_table(g_index_assact).archive_assact_id := l_actid; /* For Element archival */
873: -- Create the archive assignment action