APPS.IGS_PS_USEC_SCHEDULE dependencies on DUAL

Line 2373: SELECT INSTR(l_dbvalue,l_fndvalue,l_end_comma_index) INTO l_start_str_index FROM DUAL;

2369: FETCH c_value INTO l_dbvalue ;
2370: IF c_value%FOUND AND l_dbvalue IS NOT NULL THEN
2371: l_dbvalue:= LTRIM(RTRIM(l_dbvalue));
2372: LOOP
2373: SELECT INSTR(l_dbvalue,l_fndvalue,l_end_comma_index) INTO l_start_str_index FROM DUAL;
2374: IF l_start_str_index = 0 THEN
2375: p_isthere := 'N';
2376: return;
2377: END IF;

Line 2380: FROM DUAL;

2376: return;
2377: END IF;
2378: SELECT INSTR(SUBSTR(l_dbvalue,1,l_start_str_index),',',-1)+1
2379: INTO l_start_comma_index
2380: FROM DUAL;
2381: SELECT DECODE(
2382: INSTR(l_dbvalue,',',l_start_str_index),0,LENGTH(l_dbvalue)+1,
2383: INSTR(l_dbvalue,',',l_start_str_index))
2384: INTO l_end_comma_index

Line 2385: FROM DUAL;

2381: SELECT DECODE(
2382: INSTR(l_dbvalue,',',l_start_str_index),0,LENGTH(l_dbvalue)+1,
2383: INSTR(l_dbvalue,',',l_start_str_index))
2384: INTO l_end_comma_index
2385: FROM DUAL;
2386: SELECT LTRIM(RTRIM(SUBSTR(l_dbvalue,l_start_comma_index, l_end_comma_index-l_start_comma_index)))
2387: INTO l_temp
2388: FROM DUAL;
2389: IF l_temp = l_fndvalue THEN

Line 2388: FROM DUAL;

2384: INTO l_end_comma_index
2385: FROM DUAL;
2386: SELECT LTRIM(RTRIM(SUBSTR(l_dbvalue,l_start_comma_index, l_end_comma_index-l_start_comma_index)))
2387: INTO l_temp
2388: FROM DUAL;
2389: IF l_temp = l_fndvalue THEN
2390: p_isthere := 'Y';
2391: return;
2392: END IF;