APPS.LNS_UTILITY_PUB dependencies on HZ_RELATIONSHIPS

Line 1174: (SELECT object_id FROM hz_relationships

1170: where p.hz_party_id
1171: in
1172: (SELECT party_id FROM hz_parties
1173: WHERE party_id in
1174: (SELECT object_id FROM hz_relationships
1175: WHERE subject_id = l_subject_id
1176: AND start_date <= sysdate
1177: AND ((end_date IS null) or (end_date>=sysdate)))
1178: )