APPS.IES_SVY_DPYLMENT_STATUS_PVT dependencies on IES_SVY_SURVEYS_V

Line 61: UPDATE ies_svy_surveys_v

57: WHERE survey_id = c1_rec.survey_id
58: AND cycle_status_code = 'ACTIVE';
59:
60: if (l_cycle_count = 0) then
61: UPDATE ies_svy_surveys_v
62: SET survey_status_code = 'OPEN'
63: WHERE survey_id = c1_rec.survey_id;
64: end if;
65: