DBA Data[Home] [Help]

APPS.OKL_VIB_PVT dependencies on DUAL

Line 30: FROM DUAL

26: ln_dummy number := 0;
27:
28: CURSOR c_dnz_chr_id_validate(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
29: SELECT 1
30: FROM DUAL
31: WHERE EXISTS (SELECT id
32: FROM okc_k_headers_b
33: WHERE id = p_dnz_chr_id);
34: BEGIN

Line 120: FROM DUAL

116: CURSOR c_cle_id_validate1(p_cle_id IN OKC_K_LINES_V.ID%TYPE,
117: p_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
118: p_code2 IN OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
119: SELECT 1
120: FROM DUAL
121: WHERE EXISTS (SELECT t1.id
122: FROM okc_line_styles_b t1
123: ,okc_line_styles_b t2
124: ,okc_line_styles_b t3