APPS.OKL_SID_PVT dependencies on OKX_CUST_SITE_USES_V

Line 312: FROM OKX_CUST_SITE_USES_V

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
315: AND site_use_code = 'SHIP_TO');
316: BEGIN

Line 374: -- Description : FK validation with OKX_CUST_SITE_USES_V

370: --------------------------------------------------------------------------------
371: -- Start of Commnets
372: -- Badrinath Kuchibholta
373: -- Procedure Name : validate_shipping_id2
374: -- Description : FK validation with OKX_CUST_SITE_USES_V
375: -- Business Rules :
376: -- Parameters : OUT Return Status, IN Rec Info
377: -- Version : 1.0
378: -- End of Commnets

Line 390: FROM OKX_CUST_SITE_USES_V

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
393: AND site_use_code = 'SHIP_TO');
394: BEGIN