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.IGS_AD_PNMEMBR_DTLS_PKG dependencies on IGS_PE_TYP_INSTANCES_ALL

Line 425: FROM IGS_PE_TYP_INSTANCES_ALL TI,

421: ----------------------------------------------------------------
422: -- Cursor to check if person type of interviewer exists.
423: CURSOR c_interviewer_exist IS
424: SELECT 'x'
425: FROM IGS_PE_TYP_INSTANCES_ALL TI,
426: IGS_PE_PERSON_TYPES PT
427: WHERE ti.person_id = new_references.member_person_id
428: AND pt.system_type = 'INTERVIEWER'
429: AND (ti.end_date is NULL OR (ti.end_date IS NOT NULL AND trunc(ti.end_date) > trunc(SYSDATE)))