APPS.OKS_EXTWARPRGM_PVT dependencies on OKX_CUST_CONTACTS_V

Line 2260: FROM okx_cust_contacts_v

2256: --party id
2257: CURSOR l_cust_csr (p_contactid NUMBER)
2258: IS
2259: SELECT party_id
2260: FROM okx_cust_contacts_v
2261: WHERE id1 = p_contactid AND id2 = '#';
2262:
2263: CURSOR l_ra_hcontacts_cur (p_contact_id NUMBER)
2264: IS

Line 2315: FROM okx_cust_sites_v a, okx_cust_contacts_v b

2311: -- Contact address
2312: CURSOR address_cur_new (p_contact_id NUMBER)
2313: IS
2314: SELECT a.id1
2315: FROM okx_cust_sites_v a, okx_cust_contacts_v b
2316: WHERE b.id1 = p_contact_id
2317: AND a.id1 = b.cust_acct_site_id
2318: AND a.org_id = okc_context.get_okc_org_id;
2319: