APPS.OKL_QA_DATA_INTEGRITY dependencies on OKX_VENDOR_SITES_V

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

7690: WHERE dnz_chr_id = p_chr_id
7691: AND cle_id = p_cle_id
7692: AND jtot_object1_code = 'OKX_VENDOR';
7693:
7694: CURSOR passthru_site_csr (p_vendor_id OKX_VENDOR_SITES_V.VENDOR_ID%TYPE,
7695: p_site_id OKX_VENDOR_SITES_V.ID1%TYPE) IS
7696: SELECT 'Y'
7697: FROM okx_vendor_sites_v
7698: WHERE id1 = p_site_id

Line 7695: p_site_id OKX_VENDOR_SITES_V.ID1%TYPE) IS

7691: AND cle_id = p_cle_id
7692: AND jtot_object1_code = 'OKX_VENDOR';
7693:
7694: CURSOR passthru_site_csr (p_vendor_id OKX_VENDOR_SITES_V.VENDOR_ID%TYPE,
7695: p_site_id OKX_VENDOR_SITES_V.ID1%TYPE) IS
7696: SELECT 'Y'
7697: FROM okx_vendor_sites_v
7698: WHERE id1 = p_site_id
7699: AND vendor_id = p_vendor_id

Line 7697: FROM okx_vendor_sites_v

7693:
7694: CURSOR passthru_site_csr (p_vendor_id OKX_VENDOR_SITES_V.VENDOR_ID%TYPE,
7695: p_site_id OKX_VENDOR_SITES_V.ID1%TYPE) IS
7696: SELECT 'Y'
7697: FROM okx_vendor_sites_v
7698: WHERE id1 = p_site_id
7699: AND vendor_id = p_vendor_id
7700: AND status = 'A'
7701: AND TRUNC(SYSDATE) >= NVL(TRUNC(start_date_active), TRUNC(SYSDATE));