DBA Data[Home] [Help]

APPS.IES_SVY_DEPLOYMENT_PVT dependencies on IES_SVY_SURVEYS_V

Line 1354: UPDATE IES_SVY_SURVEYS_V

1350: FROM IES_SVY_CYCLES_V
1351: WHERE SURVEY_CYCLE_ID = l_survey_cycle_id;
1352:
1353: IF ((p_status = 'PENDING') OR (p_status = 'ACTIVE')) THEN
1354: UPDATE IES_SVY_SURVEYS_V
1355: SET SURVEY_STATUS_CODE = 'ACTIVE'
1356: WHERE SURVEY_ID = l_survey_id;
1357: END IF;
1358: END IF;