APPS.CS_KB_SECURITY_PVT dependencies on FND_USER

Line 2938: FROM fnd_user_resp_groups rg,

2934: P_SET_ID NUMBER) RETURN VARCHAR2 IS
2935:
2936: CURSOR GET_USER_RESPONSIBILITIES IS
2937: SELECT u.User_id, rg.responsibility_id, rg.responsibility_application_id
2938: FROM fnd_user_resp_groups rg,
2939: fnd_user u
2940: WHERE u.user_id = decode(P_USER_ID, -1, FND_GLOBAL.USER_ID, P_USER_ID)
2941: AND u.user_id = rg.user_id
2942: AND rg.responsibility_id = decode(P_USER_ID, -1, FND_GLOBAL.RESP_ID, rg.responsibility_id)

Line 2939: fnd_user u

2935:
2936: CURSOR GET_USER_RESPONSIBILITIES IS
2937: SELECT u.User_id, rg.responsibility_id, rg.responsibility_application_id
2938: FROM fnd_user_resp_groups rg,
2939: fnd_user u
2940: WHERE u.user_id = decode(P_USER_ID, -1, FND_GLOBAL.USER_ID, P_USER_ID)
2941: AND u.user_id = rg.user_id
2942: AND rg.responsibility_id = decode(P_USER_ID, -1, FND_GLOBAL.RESP_ID, rg.responsibility_id)
2943: AND sysdate between nvl(rg.start_date, sysdate) and nvl(rg.end_date, sysdate);