APPS.IGS_EN_WLST_GEN_PROC dependencies on FND_USER_RESP_GROUPS

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';

Line 328: l_RESP_ID fnd_user_resp_groups.responsibility_id%TYPE ;

324: l_param_list wf_parameter_list_t:=wf_parameter_list_t();
325: l_wf_installed fnd_lookups.lookup_code%TYPE;
326: v_USER_ID c_userid%ROWTYPE ;
327: l_USER_ID fnd_user.USER_ID%TYPE ;
328: l_RESP_ID fnd_user_resp_groups.responsibility_id%TYPE ;
329: l_RESP_APPL_ID fnd_user_resp_groups.responsibility_application_id%TYPE ;
330:
331: BEGIN
332: -- get the profile value that is set for checking if workflow is installed

Line 329: l_RESP_APPL_ID fnd_user_resp_groups.responsibility_application_id%TYPE ;

325: l_wf_installed fnd_lookups.lookup_code%TYPE;
326: v_USER_ID c_userid%ROWTYPE ;
327: l_USER_ID fnd_user.USER_ID%TYPE ;
328: l_RESP_ID fnd_user_resp_groups.responsibility_id%TYPE ;
329: l_RESP_APPL_ID fnd_user_resp_groups.responsibility_application_id%TYPE ;
330:
331: BEGIN
332: -- get the profile value that is set for checking if workflow is installed
333: fnd_profile.get('IGS_WF_ENABLE',l_wf_installed);