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_PS_WF_EVENT_PKG dependencies on IGS_PE_TYP_INSTANCES_ALL

Line 509: FROM igs_pe_typ_instances_all pti, igs_pe_person_types pt

505: /* Due to performance issues with igs_pe_typ_instances view, broke the view in 2 different views as shown below */
506:
507: CURSOR c_igs_person IS
508: SELECT pti.person_id
509: FROM igs_pe_typ_instances_all pti, igs_pe_person_types pt
510: WHERE NVL (pti.org_id, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99))
511: = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
512: AND pt.person_type_code = pti.person_type_code
513: AND pt.system_type IN ('STAFF','FACULTY')