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_USER_RESP_GROUPS_DIRECT

Line 190: FROM fnd_user_resp_groups_direct resp_group

186: WHERE oss.s_person_type= cp_system_person_typ
187: AND oss.responsibility_key = default_resp.responsibility_key
188: AND NOT EXISTS
189: (SELECT 1
190: FROM fnd_user_resp_groups_direct resp_group
191: WHERE user_id = cp_user_id AND
192: resp_group.responsibility_id = default_resp.responsibility_id AND
193: resp_group.responsibility_application_id = default_resp.application_id
194: );

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 227: FROM fnd_user_resp_groups_direct resp_group, fnd_responsibility resp

223:
224: ---- Get all those responsibilities associated with the System Person Type of OTHER. DELETE CASE
225: CURSOR get_resp_sys_cur(cp_user_id fnd_user.user_id%type, cp_system_person_type igs_pe_typ_rsp_dflt.s_person_type%type) IS
226: SELECT resp.application_id, resp.responsibility_id , resp.responsibility_key, resp_group.start_date, Resp_group.end_date
227: FROM fnd_user_resp_groups_direct resp_group, fnd_responsibility resp
228: WHERE user_id = cp_user_id AND
229: Resp.responsibility_id = resp_group.Responsibility_id AND
230: Resp.application_id = resp_group.responsibility_application_id
231: --AND Resp_group.end_date IS NOT NULL