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_HZ_PARTIES

Line 2122: --cur_hz_parties select statement is SELECT party_id person_id FROM igs_pe_hz_parties

2118: ******************************************************************/
2119:
2120: -- cursor for getting the person_id of the user who has logged into the application
2121: --Cursor cur_hz_parties is replaced with new cursor cur_person_id w.r.t. 2249114
2122: --cur_hz_parties select statement is SELECT party_id person_id FROM igs_pe_hz_parties
2123: --WHERE oracle_username = cp_user_name
2124: CURSOR cur_person_id( cp_user_name IN fnd_user.user_name%TYPE)
2125: IS
2126: SELECT person_party_id person_id

Line 2146: CURSOR cur_typ_instances( cp_person_id igs_pe_hz_parties.party_id%TYPE) IS

2142:
2143: -- cursor for getting the person type code of the user who has logged into the application
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