APPS.OKS_EXTWARPRGM_PVT dependencies on OKX_CUST_CONTACTS_V

Line 2220: FROM okx_cust_contacts_v

2216: --party id
2217: CURSOR l_cust_csr (p_contactid NUMBER)
2218: IS
2219: SELECT party_id
2220: FROM okx_cust_contacts_v
2221: WHERE id1 = p_contactid AND id2 = '#';
2222:
2223: CURSOR l_ra_hcontacts_cur (p_contact_id NUMBER)
2224: IS

Line 2266: FROM okx_cust_sites_v a, okx_cust_contacts_v b

2262: -- Contact address
2263: CURSOR address_cur_new (p_contact_id NUMBER)
2264: IS
2265: SELECT a.id1
2266: FROM okx_cust_sites_v a, okx_cust_contacts_v b
2267: WHERE b.id1 = p_contact_id
2268: AND a.id1 = b.cust_acct_site_id
2269: AND a.org_id = okc_context.get_okc_org_id;
2270: