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_PE_GEN_003 dependencies on FND_APPLICATION

Line 200: SELECT resp.responsibility_key, resp.responsibility_id, resp.application_id, resp_group.start_date, Resp_group.end_date, fnd.application_short_name

196:
197: -- Get the Default responsibilities mapping with the System Person Type ,
198: -- that are present with the user. Update the end date. Both INSERT/UPDATE case
199: CURSOR get_inactive_resp_cur(cp_user_id fnd_user.user_id%type, cp_system_person_type igs_pe_typ_rsp_dflt.s_person_type%type) IS
200: SELECT resp.responsibility_key, resp.responsibility_id, resp.application_id, resp_group.start_date, Resp_group.end_date, fnd.application_short_name
201: FROM fnd_user_resp_groups_direct resp_group, fnd_responsibility resp , igs_pe_typ_rsp_dflt oss, fnd_application fnd
202: WHERE user_id = cp_user_id AND
203: Resp.responsibility_id = resp_group.Responsibility_id AND
204: Resp.application_id = resp_group.responsibility_application_id AND

Line 201: FROM fnd_user_resp_groups_direct resp_group, fnd_responsibility resp , igs_pe_typ_rsp_dflt oss, fnd_application fnd

197: -- Get the Default responsibilities mapping with the System Person Type ,
198: -- that are present with the user. Update the end date. Both INSERT/UPDATE case
199: CURSOR get_inactive_resp_cur(cp_user_id fnd_user.user_id%type, cp_system_person_type igs_pe_typ_rsp_dflt.s_person_type%type) IS
200: SELECT resp.responsibility_key, resp.responsibility_id, resp.application_id, resp_group.start_date, Resp_group.end_date, fnd.application_short_name
201: FROM fnd_user_resp_groups_direct resp_group, fnd_responsibility resp , igs_pe_typ_rsp_dflt oss, fnd_application fnd
202: WHERE user_id = cp_user_id AND
203: Resp.responsibility_id = resp_group.Responsibility_id AND
204: Resp.application_id = resp_group.responsibility_application_id AND
205: oss.s_person_type = cp_system_person_type AND

Line 207: resp.application_id = fnd.application_id;

203: Resp.responsibility_id = resp_group.Responsibility_id AND
204: Resp.application_id = resp_group.responsibility_application_id AND
205: oss.s_person_type = cp_system_person_type AND
206: oss.responsibility_key = resp.responsibility_key AND
207: resp.application_id = fnd.application_id;
208:
209:
210: -- if a resp is through 2 pti. then since the event is fired after_dml, then max of null and static would return static
211: -- hence need to use l_default.