APPS.CSM_PROFILE_EVENT_PKG dependencies on ASG_USER

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;

Line 16: asg_user au

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;
20:

Line 115: ASG_USER au

111: IS
112: SELECT csm_profiles_acc_s.NEXTVAL as ACCESS_ID, au.user_id ,
113: opt.profile_option_id, opt.application_id
114: FROM fnd_profile_options opt,
115: ASG_USER au
116: WHERE (opt.profile_option_name = 'CSF_M_RECIPIENTS_BOUNDARY'
117: OR opt.profile_option_name = 'CSF_MOBILE_TASK_TIMES_UPDATABLE'
118: OR opt.profile_option_name = 'CSF_DEBRIEF_OVERLAPPING_LABOR'
119: OR opt.profile_option_name = 'INC_DEFAULT_INCIDENT_SEVERITY'

Line 253: OR (val.level_id = 10004 AND val.level_value IN (SELECT USER_ID FROM ASG_USER WHERE ENABLED= 'Y'))

249: AND val.profile_option_id = opt.profile_option_id
250: AND NVL(opt.start_date_active, SYSDATE) <= SYSDATE
251: AND NVL(opt.end_date_active, SYSDATE) >= SYSDATE
252: AND ( (val.level_id = 10001)
253: OR (val.level_id = 10004 AND val.level_value IN (SELECT USER_ID FROM ASG_USER WHERE ENABLED= 'Y'))
254: OR (val.level_id = 10002 AND val.level_value = p_csm_appl_id)
255: OR (val.level_id = 10003 AND val.level_value = p_csm_resp_id)
256: )
257: AND NOT EXISTS

Line 560: from ASG_USER

556: where application_short_name = 'CSM';
557:
558: cursor c_csm_resp(c_user_id NUMBER) is
559: select RESPONSIBILITY_ID
560: from ASG_USER
561: where USER_ID = c_user_id;
562:
563: CURSOR c_profile_seq IS
564: SELECT csm_profiles_acc_s.NEXTVAL

Line 974: FROM asg_user

970: WHERE application_short_name = 'CSM';
971:
972: CURSOR c_csm_resp (c_user_id NUMBER) IS
973: SELECT RESPONSIBILITY_ID
974: FROM asg_user
975: WHERE user_id = c_user_id;
976:
977: CURSOR c_profile_seq IS
978: SELECT csm_profiles_acc_s.NEXTVAL