3785: pt.party_id,
3786: hz.party_name party_name
3787: FROM okc_contacts_v ctc,
3788: okx_party_contacts_v pt,
3789: hz_parties hz
3790: WHERE ctc.cro_code = 'SVC_ADMIN'
3791: AND ctc.dnz_chr_id = p_chr_id
3792: AND pt.id1 = ctc.object1_id1
3793: AND pt.id2 = ctc.object1_id2
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