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_CONTACT_PREFERENCES

Line 797: SELECT contact_preference_id FROM HZ_CONTACT_PREFERENCES

793:
794: l_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.contact_preference_rec_type;
795:
796: CURSOR C_DO_PARTY(p_person_id NUMBER) IS
797: SELECT contact_preference_id FROM HZ_CONTACT_PREFERENCES
798: WHERE CONTACT_LEVEL_TABLE = 'HZ_PARTIES'
799: AND CONTACT_LEVEL_TABLE_ID = P_PERSON_ID
800: AND PREFERENCE_CODE = 'DO';
801:

Line 803: SELECT contact_preference_id FROM HZ_CONTACT_PREFERENCES

799: AND CONTACT_LEVEL_TABLE_ID = P_PERSON_ID
800: AND PREFERENCE_CODE = 'DO';
801:
802: CURSOR C_DO_NOT_PARTY(p_person_id NUMBER) IS
803: SELECT contact_preference_id FROM HZ_CONTACT_PREFERENCES
804: WHERE CONTACT_LEVEL_TABLE = 'HZ_PARTIES'
805: AND CONTACT_LEVEL_TABLE_ID = P_PERSON_ID
806: AND PREFERENCE_CODE = 'DO_NOT';
807: