APPS.IEX_UWQ_SEL_PKG dependencies on HZ_RELATIONSHIPS

Line 417: HZ_RELATIONSHIPS WHERE PARTY_ID = p_rel_partyid

413: WHERE AREA_CODE = x_AreaCode and PHONE_NUMBER = x_phonenumber;
414: -- Changed for bug#7685201 by PNAVEENK on 5-1-2009
415: CURSOR C_GetSubObj(p_rel_partyid number) is
416: SELECT object_id, subject_id from
417: HZ_RELATIONSHIPS WHERE PARTY_ID = p_rel_partyid
418: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
419: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
420: AND DIRECTIONAL_FLAG = 'F';
421: -- End for bug#7685201