DBA Data[Home] [Help]

APPS.OKS_SETUP_UTIL_PUB dependencies on HZ_PARTIES

Line 3789: hz_parties hz

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

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