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 FND_USER

Line 2124: CURSOR cur_person_id( cp_user_name IN fnd_user.user_name%TYPE)

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
2127: FROM fnd_user
2128: WHERE user_name = cp_user_name;

Line 2127: FROM fnd_user

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
2127: FROM fnd_user
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

Line 2177: l_v_logged_username fnd_user.user_name%TYPE;

2173: l_cur_person_type cur_person_type%ROWTYPE;
2174: l_cur_typ_instances cur_typ_instances%ROWTYPE;
2175: l_fun_name_rec cur_fun_name%ROWTYPE;
2176: -- Variables
2177: l_v_logged_username fnd_user.user_name%TYPE;
2178: BEGIN
2179: -- get the username of the person who has logged into the application
2180: l_v_logged_username := fnd_global.user_name();
2181: