APPS.IBE_ORD_ONECLICK_PVT dependencies on HZ_RELATIONSHIPS
Line 1229: WHERE party_id = (SELECT subject_id from HZ_RELATIONSHIPS
1225: SELECT substr(party_name,1,50) from HZ_PARTIES
1226: WHERE party_type = 'PERSON' and party_id = c_party_id
1227: UNION
1228: SELECT substr(party_name,1,50) from HZ_PARTIES 1229: WHERE party_id = (SELECT subject_id from HZ_RELATIONSHIPS 1230: WHERE party_id = c_party_id
1231: and subject_type = 'PERSON'
1232: and object_type = 'ORGANIZATION');
1233: