APPS.CSI_MASS_EDIT_PUB dependencies on DUAL

Line 334: Select 'Y' INTO l_dummy from dual where

330:
331: --Checking if it is a re-uploaded WEB ADI batch
332: IF(p_entry_id IS NOT NULL) THEN
333: BEGIN
334: Select 'Y' INTO l_dummy from dual where
335: EXISTS( select 'Y'
336: from csi_mass_edit_entries_vl cmeev, CSI_WEBADI_STAGING cws
337: WHERE cmeev.ENTRY_ID = cws.BATCH_ID
338: AND cmeev.STATUS_CODE IN ('SUCCESSFUL', 'FAILED')

Line 6142: select CSI_MU_REUPLOAD_S.NEXTVAL INTO l_new_batch_seq from DUAL;

6138: WHEN OTHERS THEN
6139: debug_out('Unable to find the old batch which is re-uploaded');
6140: END;
6141:
6142: select CSI_MU_REUPLOAD_S.NEXTVAL INTO l_new_batch_seq from DUAL;
6143:
6144: l_mass_edit_rec.name := l_old_batch_name || '_' || l_new_batch_seq;
6145: l_mass_edit_rec.description := l_old_batch_desc;
6146: l_mass_edit_rec.batch_type := 'WBADI';