APPS.IES_SVY_DEPLOYMENT_PVT dependencies on DUAL

Line 145: -- Check if Submit Deployment has been called for individual reminders

141: x_message := NULL;
142: x_msg_count := 0;
143: x_msg_data := NULL;
144:
145: -- Check if Submit Deployment has been called for individual reminders
146:
147: IF ((p_list_entry_id is not NULL) AND ( p_deployment_id is not NULL)) THEN
148: FM_Single_Request(
149: l_api_version ,

Line 212: SELECT IES_SVY_REMINDER_HST_S.nextval INTO l_reminder_hst_id FROM DUAL;

208: l_reminder_template_id := reminder_rec.reminder_template_id;
209: FOR loop_index IN 1 .. reminder_rec.no_of_reminders
210: LOOP
211: l_deploy_date := l_deploy_date + reminder_rec.reminder_interval;
212: SELECT IES_SVY_REMINDER_HST_S.nextval INTO l_reminder_hst_id FROM DUAL;
213: IF(l_deploy_date <= l_response_end_date) THEN
214: INSERT INTO ies_svy_reminder_hst_v
215: (survey_reminder_hst_id
216: ,object_version_number