APPS.CSM_USER_EVENT_PKG dependencies on ASG_USER_PUB_RESPS

Line 25: FROM asg_user_pub_resps aupr,

21:
22: CURSOR l_responsibilities_csr (p_resp_id NUMBER, l_user_id IN NUMBER)
23: IS
24: SELECT 1 --R12-Multiple Responsibility
25: FROM asg_user_pub_resps aupr,
26: asg_user asu
27: WHERE aupr.user_name = asu.user_name
28: AND aupr.responsibility_id = p_resp_id
29: AND asu.user_id = l_user_id

Line 97: asg_user_pub_resps asg_resp

93: CURSOR l_user_csr (p_user_id NUMBER)
94: IS
95: SELECT au.user_id
96: FROM asg_user au,
97: asg_user_pub_resps asg_resp
98: WHERE au.user_id <> p_user_id
99: AND au.enabled = 'Y'
100: AND asg_resp.pub_name = 'SERVICEP'
101: AND asg_resp.user_name = au.user_name;