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 3216: FROM ams_campaign_schedules_vl

3212: IS
3213:
3214: CURSOR c_owner IS
3215: SELECT owner_user_id , campaign_id
3216: FROM ams_campaign_schedules_vl
3217: WHERE schedule_id = p_schedule_id ;
3218:
3219: CURSOR c_access_csch_det(p_owner NUMBER) IS
3220: SELECT *

Line 3445: FROM ams_campaign_schedules_vl

3441: CURSOR c_schedule_det(l_csch_id NUMBER) IS
3442: SELECT schedule_name, status_code,owner_user_id,
3443: DECODE(activity_type_code,'DIRECT_SALES','SALES','DIRECT_MARKETING','DIRECT_MARKETING','OTHERS') activity_type,
3444: activity_id, start_date_time, end_date_time
3445: FROM ams_campaign_schedules_vl
3446: WHERE schedule_id = l_csch_id ;
3447: l_schedule_rec c_schedule_det%ROWTYPE;
3448:
3449: CURSOR c_emp_dtl(l_res_id IN NUMBER) IS

Line 5024: FROM ams_campaign_schedules_vl csch,

5020: camp.actual_exec_end_date,
5021: parentCSCH.start_date_time,
5022: parentCSCH.end_date_time,
5023: parentCSCH.status_code
5024: FROM ams_campaign_schedules_vl csch,
5025: ams_scheduler scheduler,
5026: ams_campaigns_all_b camp,
5027: ams_campaign_Schedules_b parentCSCH
5028: WHERE csch.schedule_id = p_schedule_id

Line 5270: FROM ams_campaign_schedules_vl csch

5266: result OUT NOCOPY VARCHAR2) IS
5267:
5268: CURSOR c_sched_data (p_schedule_id IN NUMBER) IS
5269: SELECT nvl(csch.orig_csch_id, csch.schedule_id)
5270: FROM ams_campaign_schedules_vl csch
5271: WHERE csch.schedule_id = p_schedule_id;
5272:
5273:
5274: l_schedule_id NUMBER;

Line 6125: FROM AMS_CAMPAIGN_SCHEDULES_VL

6121:
6122: CURSOR l_new_sch_det (p_new_schedule_id NUMBER) IS
6123: SELECT
6124: schedule_name
6125: FROM AMS_CAMPAIGN_SCHEDULES_VL
6126: WHERE SCHEDULE_ID = p_new_schedule_id;
6127:
6128: CURSOR l_camp_det (p_campaign_id NUMBER) IS
6129: SELECT