APPS.OKL_SID_PVT dependencies on DUAL

Line 47: FROM DUAL

43:
44: CURSOR c_cle_id_validate1(p_cle_id IN OKC_K_LINES_V.ID%TYPE,
45: p_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
46: SELECT 1
47: FROM DUAL
48: WHERE EXISTS (SELECT t1.id
49: FROM okc_line_styles_b t1
50: ,okc_line_styles_b t2
51: ,okc_subclass_top_line t3

Line 65: FROM DUAL

61: CURSOR c_cle_id_validate2(p_cle_id IN OKC_K_LINES_V.ID%TYPE,
62: p_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
63: p_code2 IN OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
64: SELECT 1
65: FROM DUAL
66: WHERE EXISTS (SELECT t1.id
67: FROM okc_line_styles_b t1
68: ,okc_line_styles_b t2
69: ,okc_line_styles_b t3

Line 207: FROM DUAL

203:
204: CURSOR c_cle_id_validate1(p_cle_id IN OKC_K_LINES_V.ID%TYPE,
205: p_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
206: SELECT 1
207: FROM DUAL
208: WHERE EXISTS (SELECT t1.id
209: FROM okc_line_styles_b t1
210: ,okc_line_styles_b t2
211: ,okc_subclass_top_line t3

Line 310: FROM DUAL

306:
307: ln_dummy number := 0;
308: CURSOR c_shipping_id1_validate(p_shipping_id1 OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID1%TYPE) is
309: SELECT 1
310: FROM DUAL
311: WHERE EXISTS (SELECT '1'
312: FROM OKX_CUST_SITE_USES_V
313: WHERE id1 = p_shipping_id1
314: AND id2 = G_ID2

Line 388: FROM DUAL

384: ln_dummy number := 0;
385: CURSOR c_shipping_id2_validate(p_shipping_id1 OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID1%TYPE,
386: p_shipping_id2 OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_ID2%TYPE) is
387: SELECT 1
388: FROM DUAL
389: WHERE EXISTS (SELECT '1'
390: FROM OKX_CUST_SITE_USES_V
391: WHERE id1 = p_shipping_id1
392: AND id2 = p_shipping_id2

Line 465: FROM DUAL

461:
462: ln_dummy number := 0;
463: CURSOR c_shipping_code_validate(p_shipping_code OKL_SUPP_INVOICE_DTLS_V.SHIPPING_ADDRESS_CODE%TYPE) is
464: SELECT 1
465: FROM DUAL
466: WHERE EXISTS (SELECT '1'
467: FROM JTF_OBJECTS_B
468: WHERE object_code = p_shipping_code);
469: BEGIN