APPS.OKS_SETUP_UTIL_PUB dependencies on OKX_CUST_CONTACTS_V

Line 3807: FROM okx_cust_contacts_v a, hz_parties b

3803: WHERE contact_point_id = p_fax_id;
3804:
3805: Cursor party_csr(p_contact_id IN Number) is
3806: SELECT b.party_name
3807: FROM okx_cust_contacts_v a, hz_parties b
3808: WHERE a.id1=p_contact_id
3809: AND a.party_id=b.party_id;
3810:
3811: Cursor contact_name_csr(p_contact_id IN Number) is

Line 3815: FROM okx_cust_contacts_v pt

3811: Cursor contact_name_csr(p_contact_id IN Number) is
3812: SELECT ltrim(rtrim(substr(pt.name,instr(pt.name,',')+1)))||' '||
3813: ltrim(rtrim(substr(pt.name,1,instr(pt.name,',')-1))) contact_name
3814: ,InitCap(ltrim(rtrim(SUBSTR(pt.name,INSTR(pt.name,',')+1)))) contact_first_name
3815: FROM okx_cust_contacts_v pt
3816: WHERE pt.id1 = p_contact_id;
3817:
3818: cursor l_qtoadd_csr (l_site_id in Number) Is
3819: SELECT

Line 3926: okx_cust_contacts_v b

3922: -- Contact address
3923: cursor address_cur_new is
3924: select a.id1
3925: from okx_cust_sites_v a,
3926: okx_cust_contacts_v b
3927: where b.id1 = p_contact_id
3928: and a.id1 = b.cust_acct_site_id;
3929:
3930: -- Primary e-mail address