APPS.LNS_WORK_FLOW dependencies on FND_USER_RESP_GROUPS

Line 568: FROM fnd_user_resp_groups usr_resp

564: l_appl_id NUMBER;
565: --Get all valid lns responsibilities for the user_id
566: CURSOR C_GET_USER_RESPS(p_user_id NUMBER,p_appl_id NUMBER) IS
567: SELECT usr_resp.responsibility_id
568: FROM fnd_user_resp_groups usr_resp
569: WHERE usr_resp.responsibility_application_id = p_appl_id
570: AND usr_resp.start_date < sysdate
571: AND usr_resp.end_date > sysdate
572: AND usr_resp.user_id = p_user_id;