APPS.OKL_QA_DATA_INTEGRITY dependencies on OKX_VENDOR_SITES_V

Line 8111: CURSOR passthru_site_csr (p_vendor_id OKX_VENDOR_SITES_V.VENDOR_ID%TYPE,

8107: WHERE dnz_chr_id = p_chr_id
8108: AND cle_id = p_cle_id
8109: AND jtot_object1_code = 'OKX_VENDOR';
8110:
8111: CURSOR passthru_site_csr (p_vendor_id OKX_VENDOR_SITES_V.VENDOR_ID%TYPE,
8112: p_site_id OKX_VENDOR_SITES_V.ID1%TYPE) IS
8113: SELECT 'Y'
8114: FROM okx_vendor_sites_v
8115: WHERE id1 = p_site_id

Line 8112: p_site_id OKX_VENDOR_SITES_V.ID1%TYPE) IS

8108: AND cle_id = p_cle_id
8109: AND jtot_object1_code = 'OKX_VENDOR';
8110:
8111: CURSOR passthru_site_csr (p_vendor_id OKX_VENDOR_SITES_V.VENDOR_ID%TYPE,
8112: p_site_id OKX_VENDOR_SITES_V.ID1%TYPE) IS
8113: SELECT 'Y'
8114: FROM okx_vendor_sites_v
8115: WHERE id1 = p_site_id
8116: AND vendor_id = p_vendor_id

Line 8114: FROM okx_vendor_sites_v

8110:
8111: CURSOR passthru_site_csr (p_vendor_id OKX_VENDOR_SITES_V.VENDOR_ID%TYPE,
8112: p_site_id OKX_VENDOR_SITES_V.ID1%TYPE) IS
8113: SELECT 'Y'
8114: FROM okx_vendor_sites_v
8115: WHERE id1 = p_site_id
8116: AND vendor_id = p_vendor_id
8117: AND status = 'A'
8118: AND TRUNC(SYSDATE) >= NVL(TRUNC(start_date_active), TRUNC(SYSDATE));