APPS.OKL_CONTRACT_BOOK_PVT dependencies on DUAL

Line 520: --IF (( l_msg_tbl(i).error_status = 'E' ) AND (INSTR(l_msg_tbl(i).data,'residual value IS less than 20') > 0)) THEN

516: --Bug# 4186455
517: /*
518: --FOR i IN 1..l_msg_tbl.COUNT
519: --LOOP
520: --IF (( l_msg_tbl(i).error_status = 'E' ) AND (INSTR(l_msg_tbl(i).data,'residual value IS less than 20') > 0)) THEN
521: --l_msg_tbl(i).error_status := 'W';
522: --END IF;
523: --END LOOP;
524: */

Line 2025: FROM DUAL

2021: p_okl_free_form okc_k_lines_b.ID%TYPE,
2022: p_oks_cov_prod okc_k_lines_b.ID%TYPE
2023: ) IS
2024: SELECT 'Y' y
2025: FROM DUAL
2026: WHERE EXISTS (
2027: SELECT 'Y' y
2028: FROM okl_strm_elements_v ele,
2029: okl_streams_v strm,

Line 2065: FROM DUAL

2061: p_okl_free_form okc_k_lines_b.ID%TYPE,
2062: p_oks_cov_prod okc_k_lines_b.ID%TYPE
2063: ) IS
2064: SELECT 'Y' y
2065: FROM DUAL
2066: WHERE EXISTS (
2067: SELECT 'Y' y
2068: FROM okl_strm_elements_v ele,
2069: okl_streams_v strm,