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

Line 2148: FROM igs_pe_typ_instances_all

2144: -- depending on the course code passed into the function
2145: -- cursor is modified for performance bug 3696901
2146: CURSOR cur_typ_instances( cp_person_id igs_pe_hz_parties.party_id%TYPE) IS
2147: SELECT person_type_code
2148: FROM igs_pe_typ_instances_all
2149: WHERE person_id = cp_person_id AND
2150: course_cd = NVL(p_course_cd,course_cd) AND
2151: end_date IS NULL AND
2152: person_type_code IN ( SELECT person_type_code