APPS.PV_ENRQ_BINS_PVT dependencies on HZ_RELATIONSHIPS

Line 100: ,hz_relationships rel

96: CURSOR global_id_csr(p_sub_ptr_id NUMBER) IS
97: SELECT glob_prof.partner_id
98: FROM pv_partner_profiles subs_prof
99: ,pv_partner_profiles glob_prof
100: ,hz_relationships rel
101: WHERE rel.subject_id=subs_prof.partner_party_id
102: AND rel.relationship_code = 'SUBSIDIARY_OF'
103: AND rel.relationship_type = 'PARTNER_HIERARCHY'
104: AND rel.status = 'A'