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 535: --Replaced the view HZ_PARTY_RELATIONSHIPS with HZ_RELATIONSHIPS and

531: AND CONTACT_LEVEL_TABLE_ID = P_PERSON_ID
532: AND PREFERENCE_CODE = 'DO_NOT';
533:
534: --Begin Bug#4597394 schekuri 08-Sep-2005
535: --Replaced the view HZ_PARTY_RELATIONSHIPS with HZ_RELATIONSHIPS and
536: --added necessary filter conditions
537: CURSOR C_PARTY(p_org_party_id NUMBER) IS
538: SELECT
539: P.PARTY_ID

Line 542: HZ_RELATIONSHIPS REL

538: SELECT
539: P.PARTY_ID
540: -- , P.PARTY_NAME
541: FROM
542: HZ_RELATIONSHIPS REL
543: , HZ_PARTIES C
544: , HZ_PARTIES P
545: , HZ_PARTIES O
546: WHERE O.PARTY_TYPE = 'ORGANIZATION'