APPS.LNS_WORK_FLOW dependencies on FND_USER_RESP_GROUPS

Line 137: FND_USER_RESP_GROUPS urg,

133: resp.responsibility_key,
134: resp.request_group_id,
135: rgr.request_group_name
136: from fnd_user usr,
137: FND_USER_RESP_GROUPS urg,
138: fnd_responsibility resp,
139: FND_REQUEST_GROUPS rgr
140: where
141: usr.user_id = p_user_id and

Line 856: FROM fnd_user_resp_groups usr_resp

852: l_appl_id NUMBER;
853: --Get all valid lns responsibilities for the user_id
854: CURSOR C_GET_USER_RESPS(p_user_id NUMBER,p_appl_id NUMBER) IS
855: SELECT usr_resp.responsibility_id
856: FROM fnd_user_resp_groups usr_resp
857: WHERE usr_resp.responsibility_application_id = p_appl_id
858: AND trunc(sysdate) between trunc(nvl(usr_resp.start_date, sysdate)) and trunc(nvl(usr_resp.end_date, sysdate))
859: -- AND usr_resp.start_date < sysdate AND nvl(usr_resp.end_date,sysdate-1) > sysdate -- Bug#8247186
860: AND usr_resp.user_id = p_user_id;