APPS.BIS_RG_SCHEDULES_PVT dependencies on WF_NOTIFICATIONS

Line 2183: from wf_notifications w, bis_schedule_preferences sp

2179: for c1 in cNotificationSchedules loop
2180: -- Check if the notification is closed
2181: select count(*)
2182: into vCount
2183: from wf_notifications w, bis_schedule_preferences sp
2184: where sp.schedule_id = c1.schedule_id
2185: and w.recipient_role = gvRoleName||sp.file_id
2186: and w.status = 'CLOSED';
2187:

Line 2201: from wf_notifications w

2197:
2198: delete fnd_lobs
2199: where file_id in(
2200: select substr(recipient_role, Length(gvRoleName)+1)
2201: from wf_notifications w
2202: where w.recipient_role like gvRoleName || '%'
2203: and status = 'CLOSED');
2204:
2205:

Line 2351: from bis_schedule_preferences sp, wf_notifications w

2347: for c1 in cUserFiles(pScheduleId, pUserId, pPlugId) loop
2348:
2349: select count(*)
2350: into vCount
2351: from bis_schedule_preferences sp, wf_notifications w
2352: where file_id = c1.file_id
2353: and w.recipient_role = gvRoleName||sp.file_id
2354: and w.status = 'CLOSED';
2355: