APPS.AS_RESOURCE_MERGE_PUB dependencies on HZ_RELATIONSHIPS

Line 47: (select party_id from hz_relationships

43: cursor c_get_from_resource (c_resource_id NUMBER) is
44: select resource_id from jtf_rs_resource_extns
45: where category in ('PARTNER', 'PARTY')
46: and source_id =
47: (select party_id from hz_relationships
48: where relationship_id=
49: (select merge_to_entity_id from hz_merge_party_details
50: where merge_from_entity_id =
51: (select relationship_id

Line 52: from hz_relationships

48: where relationship_id=
49: (select merge_to_entity_id from hz_merge_party_details
50: where merge_from_entity_id =
51: (select relationship_id
52: from hz_relationships
53: where party_id=
54: (select source_id
55: from jtf_rs_resource_extns
56: where resource_id=c_resource_id) ) ) );