DBA Data[Home] [Help]

APPS.OKL_VFA_PVT dependencies on DUAL

Line 31: FROM DUAL

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

Line 119: FROM DUAL

115:
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) IS
118: SELECT 1
119: FROM DUAL
120: WHERE EXISTS (SELECT t1.id
121: FROM okc_line_styles_b t1
122: ,okc_line_styles_b t2
123: ,okc_subclass_top_line t3