APPS.CSM_EMAIL_QUERY_PKG dependencies on ASG_RESPONSIBILITY_VL

Line 176: asg_responsibility_vl mresp

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
180: AND resp.start_date <= sysdate