APPS.IBU_SR_UTIL dependencies on HZ_RELATIONSHIPS

Line 247: SELECT /*+ index(HZ_RELATIONSHIPS_N2) */ party_id

243:
244: AS
245:
246: BEGIN
247: SELECT /*+ index(HZ_RELATIONSHIPS_N2) */ party_id
248: INTO x_party_id
249: FROM hz_relationships
250: WHERE object_id = p_Object_Id
251: AND object_type='ORGANIZATION'

Line 249: FROM hz_relationships

245:
246: BEGIN
247: SELECT /*+ index(HZ_RELATIONSHIPS_N2) */ party_id
248: INTO x_party_id
249: FROM hz_relationships
250: WHERE object_id = p_Object_Id
251: AND object_type='ORGANIZATION'
252: AND subject_id = p_Subject_Id
253: AND subject_type ='PERSON'