DBA Data[Home] [Help]

APPS.OKL_CONTRACT_BOOK_PVT dependencies on DUAL

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

422: --Bug# 4186455
423: /*
424: --FOR i IN 1..l_msg_tbl.COUNT
425: --LOOP
426: --IF (( l_msg_tbl(i).error_status = 'E' ) AND (INSTR(l_msg_tbl(i).data,'residual value IS less than 20') > 0)) THEN
427: --l_msg_tbl(i).error_status := 'W';
428: --END IF;
429: --END LOOP;
430: */

Line 1721: FROM DUAL

1717: p_okl_free_form okc_k_lines_b.ID%TYPE,
1718: p_oks_cov_prod okc_k_lines_b.ID%TYPE
1719: ) IS
1720: SELECT 'Y' y
1721: FROM DUAL
1722: WHERE EXISTS (
1723: SELECT 'Y' y
1724: FROM okl_strm_elements_v ele,
1725: okl_streams_v strm,

Line 1761: FROM DUAL

1757: p_okl_free_form okc_k_lines_b.ID%TYPE,
1758: p_oks_cov_prod okc_k_lines_b.ID%TYPE
1759: ) IS
1760: SELECT 'Y' y
1761: FROM DUAL
1762: WHERE EXISTS (
1763: SELECT 'Y' y
1764: FROM okl_strm_elements_v ele,
1765: okl_streams_v strm,