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

Line 2132: CURSOR cur_person_type( cp_person_id igs_pe_typ_instances.person_id%TYPE)

2128: WHERE user_name = cp_user_name;
2129: -- cursor for getting the person type code of the user who has logged into the application
2130: -- minimum rank for the person id is returned
2131: -- cursor is modified for performance bug 3713057
2132: CURSOR cur_person_type( cp_person_id igs_pe_typ_instances.person_id%TYPE)
2133: IS
2134: SELECT pti.person_type_code
2135: FROM igs_pe_typ_instances pti,
2136: igs_pe_person_types pt

Line 2135: FROM igs_pe_typ_instances pti,

2131: -- cursor is modified for performance bug 3713057
2132: CURSOR cur_person_type( cp_person_id igs_pe_typ_instances.person_id%TYPE)
2133: IS
2134: SELECT pti.person_type_code
2135: FROM igs_pe_typ_instances pti,
2136: igs_pe_person_types pt
2137: WHERE pti.person_id = cp_person_id AND
2138: pti.person_type_code = pt.person_type_code AND
2139: pt.system_type = 'SS_ENROLL_STAFF' AND

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