eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_WF_BAN_STATUS_PUB dependencies on HZ_RELATIONSHIPS

Line 809: --Replaced the view HZ_PARTY_RELATIONSHIPS with HZ_RELATIONSHIPS and

805: AND CONTACT_LEVEL_TABLE_ID = P_PERSON_ID
806: AND PREFERENCE_CODE = 'DO_NOT';
807:
808: --Begin Bug#4597394 schekuri 08-Sep-2005
809: --Replaced the view HZ_PARTY_RELATIONSHIPS with HZ_RELATIONSHIPS and
810: --added necessary filter conditions
811: CURSOR C_PARTY(p_org_party_id NUMBER) IS
812: SELECT
813: P.PARTY_ID

Line 816: HZ_RELATIONSHIPS REL

812: SELECT
813: P.PARTY_ID
814: -- , P.PARTY_NAME
815: FROM
816: HZ_RELATIONSHIPS REL
817: , HZ_PARTIES C
818: , HZ_PARTIES P
819: , HZ_PARTIES O
820: WHERE O.PARTY_TYPE = 'ORGANIZATION'