APPS.IES_SVY_DEPLOYMENT_PVT dependencies on IES_SVY_REMINDER_HST_V

Line 214: INSERT INTO ies_svy_reminder_hst_v

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
217: ,created_by
218: ,creation_date

Line 252: UPDATE ies_svy_reminder_hst_v

248: argument9 => l_reminder_hst_id);
249: IF (l_schedule_id = 0) THEN
250: RAISE FND_API.G_EXC_ERROR;
251: ELSE
252: UPDATE ies_svy_reminder_hst_v
253: SET CONCURRENT_REQ_ID = l_schedule_id
254: WHERE SURVEY_REMINDER_HST_ID = l_reminder_hst_id;
255: END IF;
256: END IF;

Line 1000: UPDATE ies_svy_reminder_hst_v

996:
997: ELSIF(p_reminder_type = 'REMINDER') THEN
998: --else a record should be inserted in ies_svy_reminder_hst if its a reminder
999:
1000: UPDATE ies_svy_reminder_hst_v
1001: SET fulfillment_req_id = l_request_id
1002: WHERE SURVEY_REMINDER_HST_ID = p_reminder_hst_id;
1003:
1004: END IF;