[Home] [Help]
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