APPS.OKS_EXTWARPRGM_PVT dependencies on OKX_CUST_SITE_USES_V

Line 2253: FROM okx_customer_accounts_v ca, okx_cust_site_uses_v cs

2249: --Third party id
2250: CURSOR l_thirdparty_csr (p_id NUMBER)
2251: IS
2252: SELECT ca.party_id
2253: FROM okx_customer_accounts_v ca, okx_cust_site_uses_v cs
2254: WHERE ca.id1 = cs.cust_account_id AND cs.id1 = p_id;
2255:
2256: --party id
2257: CURSOR l_cust_csr (p_contactid NUMBER)

Line 3867: FROM okx_cust_site_uses_v

3863:
3864: CURSOR l_billto_csr (p_billto NUMBER)
3865: IS
3866: SELECT cust_account_id
3867: FROM okx_cust_site_uses_v
3868: WHERE id1 = p_billto AND id2 = '#';
3869:
3870: CURSOR l_ra_hcontacts_cur (p_contact_id NUMBER)
3871: IS

Line 9755: FROM okx_cust_site_uses_v

9751: IS
9752: CURSOR l_address_csr
9753: IS
9754: SELECT id1
9755: FROM okx_cust_site_uses_v
9756: WHERE cust_account_id = p_customer_id
9757: AND party_id = p_party_id
9758: AND site_use_code = p_code
9759: AND identifying_address_flag = 'Y'

Line 9821: FROM okx_cust_site_uses_v

9817: p_site_use_code VARCHAR2
9818: )
9819: IS
9820: SELECT 'x'
9821: FROM okx_cust_site_uses_v
9822: WHERE id1 = p_id
9823: AND site_use_code = p_site_use_code
9824: AND org_id = p_org_id
9825: AND status = 'A';