APPS.OKS_CONTRACTS_PUB dependencies on OKX_CUST_CONTACTS_V

Line 1092: SELECT Party_Id From OKX_CUST_CONTACTS_V

1088: SELECT Party_Id From OKX_CUST_SITE_USES_V
1089: WHERE ID1 = p_id;
1090:
1091: CURSOR l_cust_csr (p_contactid Number) IS
1092: SELECT Party_Id From OKX_CUST_CONTACTS_V
1093: WHERE Id1 = p_contactid And id2 = '#';
1094:
1095: CURSOR l_ra_hcontacts_cur (p_contact_id number) Is
1096: SELECT hzr.object_id, hzr.party_id

Line 1621: FROM okx_cust_sites_v a, okx_cust_contacts_v b

1617:
1618: -- Contact address
1619: CURSOR address_cur_new( p_contact_id NUMBER ) IS
1620: SELECT a.id1
1621: FROM okx_cust_sites_v a, okx_cust_contacts_v b
1622: WHERE b.id1 = p_contact_id
1623: AND a.id1 = b.cust_acct_site_id;
1624:
1625: -- Primary e-mail address