APPS.CSM_EMAIL_QUERY_PKG dependencies on FND_USER_RESP_GROUPS

Line 165: fnd_user_resp_groups resp

161:
162: CURSOR c_user_resp(p_user_id NUMBER, p_resp_id NUMBER) IS
163: SELECT resp.responsibility_id
164: FROM fnd_user usr,
165: fnd_user_resp_groups resp
166: WHERE usr.user_id = p_user_id
167: AND resp.responsibility_id = p_resp_id
168: AND usr.user_id = resp.user_id
169: AND resp.start_date <= sysdate

Line 175: fnd_user_resp_groups resp,

171:
172: CURSOR c_mobile_user_resp(p_user_id NUMBER) IS
173: SELECT resp.responsibility_id
174: FROM fnd_user usr,
175: fnd_user_resp_groups resp,
176: asg_responsibility_vl mresp
177: WHERE usr.user_id = p_user_id
178: AND resp.responsibility_id = mresp.responsibility_id
179: AND usr.user_id = resp.user_id