APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_VL

Line 1237: FROM ams_campaign_schedules_vl

1233: WHERE user_id = FND_GLOBAL.user_id ;
1234:
1235: CURSOR c_schedule IS
1236: SELECT *
1237: FROM ams_campaign_schedules_vl
1238: WHERE schedule_id = p_schedule_rec.schedule_id;
1239:
1240: CURSOR c_bud_line IS
1241: SELECT 1

Line 3228: FROM ams_campaign_schedules_vl

3224: IS
3225:
3226: CURSOR c_owner IS
3227: SELECT owner_user_id , campaign_id
3228: FROM ams_campaign_schedules_vl
3229: WHERE schedule_id = p_schedule_id ;
3230:
3231: CURSOR c_access_csch_det(p_owner NUMBER) IS
3232: SELECT *

Line 3457: FROM ams_campaign_schedules_vl

3453: CURSOR c_schedule_det(l_csch_id NUMBER) IS
3454: SELECT schedule_name, status_code,owner_user_id,
3455: DECODE(activity_type_code,'DIRECT_SALES','SALES','DIRECT_MARKETING','DIRECT_MARKETING','OTHERS') activity_type,
3456: activity_id, start_date_time, end_date_time
3457: FROM ams_campaign_schedules_vl
3458: WHERE schedule_id = l_csch_id ;
3459: l_schedule_rec c_schedule_det%ROWTYPE;
3460:
3461: CURSOR c_emp_dtl(l_res_id IN NUMBER) IS

Line 5054: FROM ams_campaign_schedules_vl csch,

5050: camp.actual_exec_end_date,
5051: parentCSCH.start_date_time,
5052: parentCSCH.end_date_time,
5053: parentCSCH.status_code
5054: FROM ams_campaign_schedules_vl csch,
5055: ams_scheduler scheduler,
5056: ams_campaigns_all_b camp,
5057: ams_campaign_Schedules_b parentCSCH
5058: WHERE csch.schedule_id = p_schedule_id

Line 5300: FROM ams_campaign_schedules_vl csch

5296: result OUT NOCOPY VARCHAR2) IS
5297:
5298: CURSOR c_sched_data (p_schedule_id IN NUMBER) IS
5299: SELECT nvl(csch.orig_csch_id, csch.schedule_id)
5300: FROM ams_campaign_schedules_vl csch
5301: WHERE csch.schedule_id = p_schedule_id;
5302:
5303:
5304: l_schedule_id NUMBER;

Line 6155: FROM AMS_CAMPAIGN_SCHEDULES_VL

6151:
6152: CURSOR l_new_sch_det (p_new_schedule_id NUMBER) IS
6153: SELECT
6154: schedule_name
6155: FROM AMS_CAMPAIGN_SCHEDULES_VL
6156: WHERE SCHEDULE_ID = p_new_schedule_id;
6157:
6158: CURSOR l_camp_det (p_campaign_id NUMBER) IS
6159: SELECT