APPS.AMS_CAMP_SCHEDULE_PVT dependencies on DUAL

Line 120: FROM dual;

116:
117: l_schedule_rec schedule_rec_type := p_schedule_rec ;
118: CURSOR c_id IS
119: SELECT ams_campaign_schedules_b_s.NEXTVAL
120: FROM dual;
121:
122: CURSOR c_id_exists (l_id IN NUMBER) IS
123: SELECT 1 FROM dual
124: WHERE EXISTS (SELECT 1 FROM AMS_CAMPAIGN_SCHEDULES_B

Line 123: SELECT 1 FROM dual

119: SELECT ams_campaign_schedules_b_s.NEXTVAL
120: FROM dual;
121:
122: CURSOR c_id_exists (l_id IN NUMBER) IS
123: SELECT 1 FROM dual
124: WHERE EXISTS (SELECT 1 FROM AMS_CAMPAIGN_SCHEDULES_B
125: WHERE SCHEDULE_ID = l_id);
126:
127: --CURSOR c_trig_exists (l_schedule_id IN NUMBER) IS

Line 128: -- SELECT 1 FROM dual

124: WHERE EXISTS (SELECT 1 FROM AMS_CAMPAIGN_SCHEDULES_B
125: WHERE SCHEDULE_ID = l_id);
126:
127: --CURSOR c_trig_exists (l_schedule_id IN NUMBER) IS
128: -- SELECT 1 FROM dual
129: -- WHERE EXISTS (SELECT 1 FROM ams_campaign_schedules_b
130: -- WHERE campaign_id = p_schedule_rec.campaign_id
131: -- AND trigger_id = p_schedule_rec.trigger_id
132: -- AND schedule_id <> l_schedule_id );

Line 3222: SELECT 1 from dual

3218: l_status_code VARCHAR2(30);
3219: l_rollup_type VARCHAR2(30);
3220:
3221: CURSOR c_sch_name IS
3222: SELECT 1 from dual
3223: WHERE EXISTS (SELECT *
3224: FROM ams_campaign_schedules_vl
3225: WHERE campaign_id = p_complete_rec.campaign_id
3226: AND UPPER(schedule_name) = UPPER(p_complete_rec.schedule_name)) ;

Line 3229: SELECT 1 from dual

3225: WHERE campaign_id = p_complete_rec.campaign_id
3226: AND UPPER(schedule_name) = UPPER(p_complete_rec.schedule_name)) ;
3227:
3228: CURSOR c_sch_name_updt IS
3229: SELECT 1 from dual
3230: WHERE EXISTS (SELECT *
3231: FROM ams_campaign_schedules_vl
3232: WHERE campaign_id = p_complete_rec.campaign_id
3233: AND UPPER(schedule_name) = UPPER(p_complete_rec.schedule_name)