APPS.PER_ES_COMP_CERT_ARCHIVE_PKG dependencies on DUAL

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

149: -- Return cursor that selects no rows
150: sqlstr := 'select 1 '||
151: '/* ERROR - Employer Details Fetch failed with: '||
152: sqlerrm(sqlcode)||' */ '||
153: 'from dual where to_char(:payroll_action_id) = dummy';
154: hr_utility.set_location(' Leaving: range code',110);
155: END range_code;
156: --------------------------------------------------------------------------------
157: -- ACTION_CREATION_CODE

Line 273: FROM dual;

269: ,l_business_group_id) LOOP
270: --
271: SELECT pay_assignment_actions_s.NEXTVAL
272: INTO l_actid
273: FROM dual;
274: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
275: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,p_actid,chunk,NULL);
276: END LOOP;
277: --

Line 288: FROM dual;

284: ,l_business_group_id) LOOP
285: --
286: SELECT pay_assignment_actions_s.NEXTVAL
287: INTO l_actid
288: FROM dual;
289: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
290: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,p_actid,chunk,NULL);
291: END LOOP;
292: --

Line 932: SELECT userenv('LANGUAGE') INTO g_nls_db_char FROM dual;

928: BEGIN
929: --
930: hr_utility.set_location('Entered Procedure clob to blob',120);
931: --
932: SELECT userenv('LANGUAGE') INTO g_nls_db_char FROM dual;
933: --
934: l_buffer_len := 20000;
935: l_length_clob := dbms_lob.getlength(p_clob);
936: l_offset := 1;