APPS.PER_HU_EMP_CERT_ARCHIVE dependencies on DUAL

Line 160: 'from dual where to_char(:payroll_action_id) = dummy';

156: -- Return cursor that selects no rows
157: sqlstr := 'select 1 '||
158: '/* ERROR - Employer Details Fetch failed with: '||
159: sqlerrm(sqlcode)||' */ '||
160: 'from dual where to_char(:payroll_action_id) = dummy';
161: END range_code;
162:
163: --------------------------------------------------------------------------------
164: -- ACTION_CREATION_CODE

Line 235: FROM dual;

231: ,l_payroll_id) LOOP
232: --
233: SELECT pay_assignment_actions_s.NEXTVAL
234: INTO l_actid
235: FROM dual;
236: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
237: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,p_actid,chunk,NULL);
238: END LOOP;
239: