APPS.OKS_SETUP_UTIL_PUB dependencies on OKX_CUST_CONTACTS_V

Line 3816: FROM okx_cust_contacts_v a, hz_parties b

3812: WHERE contact_point_id = p_fax_id;
3813:
3814: Cursor party_csr(p_contact_id IN Number) is
3815: SELECT b.party_name
3816: FROM okx_cust_contacts_v a, hz_parties b
3817: WHERE a.id1=p_contact_id
3818: AND a.party_id=b.party_id;
3819:
3820: Cursor contact_name_csr(p_contact_id IN Number) is

Line 3824: FROM okx_cust_contacts_v pt

3820: Cursor contact_name_csr(p_contact_id IN Number) is
3821: SELECT ltrim(rtrim(substr(pt.name,instr(pt.name,',')+1)))||' '||
3822: ltrim(rtrim(substr(pt.name,1,instr(pt.name,',')-1))) contact_name
3823: ,InitCap(ltrim(rtrim(SUBSTR(pt.name,INSTR(pt.name,',')+1)))) contact_first_name
3824: FROM okx_cust_contacts_v pt
3825: WHERE pt.id1 = p_contact_id;
3826:
3827: cursor l_qtoadd_csr (l_site_id in Number) Is
3828: SELECT

Line 3935: okx_cust_contacts_v b

3931: -- Contact address
3932: cursor address_cur_new is
3933: select a.id1
3934: from okx_cust_sites_v a,
3935: okx_cust_contacts_v b
3936: where b.id1 = p_contact_id
3937: and a.id1 = b.cust_acct_site_id;
3938:
3939: -- Primary e-mail address