DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on HZ_CONTACT_POINTS

Line 15400: hz_contact_points hcpp,

15396: into p_vendor_contact_rec.per_party_id,
15397: p_vendor_contact_rec.relationship_id,
15398: p_vendor_contact_rec.rel_party_id
15399: from hz_parties hpc,
15400: hz_contact_points hcpp,
15401: hz_contact_points hcpe,
15402: hz_relationships hr
15403: where hr.subject_id = l_vend_party_id --
15404: And hcpp.owner_table_name(+) = 'HZ_PARTIES'

Line 15401: hz_contact_points hcpe,

15397: p_vendor_contact_rec.relationship_id,
15398: p_vendor_contact_rec.rel_party_id
15399: from hz_parties hpc,
15400: hz_contact_points hcpp,
15401: hz_contact_points hcpe,
15402: hz_relationships hr
15403: where hr.subject_id = l_vend_party_id --
15404: And hcpp.owner_table_name(+) = 'HZ_PARTIES'
15405: And hcpp.owner_table_id(+) = hr.PARTY_ID