APPS.BIS_RG_SEND_NOTIFICATIONS_PVT dependencies on BIS_SCHEDULER

Line 8: -- DESCRIPTION: Private package to create records in BIS_SCHEDULER

4: -- dbdrv: checkfile:~PROD:~PATH:~FILE
5: ----------------------------------------------------------------------------
6: -- PACKAGE: BIS_SCHEDULE_PVT
7: -- --
8: -- DESCRIPTION: Private package to create records in BIS_SCHEDULER
9: --
10: -- --
11: -- MODIFICATIONS --
12: -- Date User Modification

Line 51: FROM bis_scheduler

47: -- mdamle 09/04/01 Scheduling Enhancements - Phase II - Multiple Preferences per schedule
48: /*
49: CURSOR c_sched IS
50: SELECT title, function_name, schedule_id
51: FROM bis_scheduler
52: WHERE schedule_id = p_schedule_id;
53: */
54: CURSOR c_sched IS
55: SELECT sp.file_id, sp.title, s.function_name, s.schedule_id

Line 56: FROM bis_scheduler s, bis_schedule_preferences sp

52: WHERE schedule_id = p_schedule_id;
53: */
54: CURSOR c_sched IS
55: SELECT sp.file_id, sp.title, s.function_name, s.schedule_id
56: FROM bis_scheduler s, bis_schedule_preferences sp
57: WHERE sp.schedule_id = p_schedule_id
58: and sp.file_id = p_file_id
59: and s.schedule_id = sp.schedule_id
60: and sp.user_id = p_user_id