APPS.IBU_SR_UTIL dependencies on HZ_RELATIONSHIPS

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

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

Line 250: FROM hz_relationships

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