APPS.AP_VENDOR_PUB_PKG dependencies on HZ_RELATIONSHIPS

Line 2783: FROM hz_relationships

2779: x_valid := TRUE;
2780:
2781: SELECT relationship_id
2782: INTO l_dummy
2783: FROM hz_relationships
2784: WHERE relationship_id = p_relationship_id
2785: AND rownum < 2;
2786:
2787:

Line 15402: hz_relationships hr

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
15406: And hcpp.phone_line_type(+) = 'GEN'