APPS.CSM_PROFILE_EVENT_PKG dependencies on ASG_USER_PUB_RESPS

Line 15: FROM asg_user_pub_resps aupr,

11:
12: CURSOR l_omfs_resp_palm_users_csr(p_resp_id IN number)
13: IS
14: SELECT au.user_id
15: FROM asg_user_pub_resps aupr,
16: asg_user au
17: WHERE aupr.pub_name = 'SERVICEP'
18: AND aupr.responsibility_id = p_resp_id
19: AND au.user_name = aupr.user_name;