DBA Data[Home] [Help]

APPS.IGP_VW_GEN_002_PKG dependencies on FND_RESPONSIBILITY_VL

Line 40: FROM fnd_user fnd, fnd_responsibility_vl resp , fnd_user_resp_groups_direct rg

36: l_error_message VARCHAR2(500);
37:
38: CURSOR c_career_center(cp_app_id IN NUMBER,cp_resp_key IN VARCHAR) IS
39: SELECT fnd.user_name
40: FROM fnd_user fnd, fnd_responsibility_vl resp , fnd_user_resp_groups_direct rg
41: WHERE rg.user_id = fnd.user_id AND
42: rg.responsibility_id = resp.responsibility_id AND
43: rg.responsibility_application_id = cp_app_id AND
44: resp.responsibility_key = cp_resp_key ;