APPS.IGS_UC_EXT_MARVIN dependencies on DUAL

Line 179: FROM DUAL ;

175: WHERE name ='utl_file_dir';
176:
177: CURSOR cur_db_dir IS
178: SELECT DECODE( INSTR(l_dbvalue,',',l_start_str_index),0,LENGTH(l_dbvalue)+1, INSTR(l_dbvalue,',',l_start_str_index) )
179: FROM DUAL ;
180:
181: BEGIN
182:
183: -- Initialize the OUT variable

Line 378: FROM DUAL;

374: cur_transactions_rec cur_transactions%ROWTYPE;
375:
376: CURSOR cur_get_mon(p_mon NUMBER) IS
377: SELECT TO_CHAR(TO_DATE(p_mon,'MM'),'MON') entry_month
378: FROM DUAL;
379: l_cur_get_mon cur_get_mon%ROWTYPE;
380:
381: -- Fetching Course Vacancy Records to be exported
382: CURSOR cur_uv_crs_vac(cp_system_code igs_uc_crse_dets.system_code%TYPE) IS