APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on ASG_USER

Line 79: asg_user au

75: -- get all notifications in which user is a recipient
76: CURSOR c_notf(b_user_id fnd_user.user_id%TYPE) IS
77: SELECT DISTINCT wfn.notification_id
78: FROM wf_notifications wfn,
79: asg_user au
80: WHERE au.user_id=b_user_id
81: AND au.user_name IN (FROM_ROLE,RECIPIENT_ROLE)
82: AND (nvl(wfn.begin_date, sysdate) between
83: (sysdate - csm_profile_pkg.get_task_history_days(b_user_id))and sysdate)

Line 93: ASG_USER au

89: --12.1
90: CURSOR c_broadcast_notf(b_user_id fnd_user.user_id%TYPE) IS
91: SELECT DISTINCT wfn.notification_id
92: FROM WF_NOTIFICATIONS wfn,
93: ASG_USER au
94: WHERE au.user_id=b_user_id
95: AND RECIPIENT_ROLE LIKE 'JRES_GRP:%'
96: AND au.user_id =CSM_UTIL_PKG.get_group_owner(substr(WFN.RECIPIENT_ROLE,instr(WFN.RECIPIENT_ROLE,':')+1))
97: AND au.enabled='Y'

Line 140: ASG_USER au

136: IS
137: CURSOR c_users(b_nid NUMBER) IS
138: SELECT DISTINCT au.user_id
139: FROM WF_NOTIFICATIONS wfn,
140: ASG_USER au
141: WHERE wfn.NOTIFICATION_ID=b_nid
142: AND au.user_name IN (WFN.FROM_ROLE,WFN.RECIPIENT_ROLE)
143: AND au.enabled='Y'
144: AND (nvl(wfn.begin_date, sysdate) between

Line 155: ASG_USER au

151: --12.1
152: CURSOR c_broadcast_users(b_nid NUMBER) IS
153: SELECT DISTINCT au.user_id
154: FROM WF_NOTIFICATIONS wfn,
155: ASG_USER au
156: WHERE wfn.NOTIFICATION_ID=b_nid
157: AND RECIPIENT_ROLE LIKE 'JRES_GRP:%'
158: AND au.user_id =CSM_UTIL_PKG.get_group_owner(substr(WFN.RECIPIENT_ROLE,instr(WFN.RECIPIENT_ROLE,':')+1))
159: AND au.enabled='Y'