DBA Data[Home] [Help]

APPS.IES_SVY_DEPLOYMENT_PVT dependencies on IES_SVY_REMINDER_HST_S

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