DBA Data[Home] [Help]

APPS.OKS_SETUP_UTIL_PUB dependencies on HZ_PARTIES

Line 3780: hz_parties hz

3776: pt.party_id,
3777: hz.party_name party_name
3778: FROM okc_contacts_v ctc,
3779: okx_party_contacts_v pt,
3780: hz_parties hz
3781: WHERE ctc.cro_code = 'SVC_ADMIN'
3782: AND ctc.dnz_chr_id = p_chr_id
3783: AND pt.id1 = ctc.object1_id1
3784: AND pt.id2 = ctc.object1_id2

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