APPS.IGS_EN_WLST_GEN_PROC dependencies on FND_RESPONSIBILITY

Line 316: FROM fnd_user_resp_groups rg, fnd_responsibility r

312:
313: CURSOR c_resp (cp_user_id fnd_user.user_id%type) IS
314: SELECT rg.responsibility_id,
315: rg.responsibility_application_id
316: FROM fnd_user_resp_groups rg, fnd_responsibility r
317: WHERE rg.user_id = cp_user_id
318: AND SYSDATE BETWEEN rg.start_date AND NVL(rg.end_date,(SYSDATE+1))
319: AND r.responsibility_id = rg.responsibility_id
320: AND r.responsibility_key = 'IGS_SS_FACULTY';