DBA Data[Home] [Help]

APPS.IES_SURVEY_SUMMARY dependencies on IES_SVY_QUES_DATA_V

Line 492: UPDATE ies_svy_ques_data_v

488: BEGIN
489: SAVEPOINT Create_Summary;
490:
491: FOR anscountfree_rec IN anscountfree_cur LOOP
492: UPDATE ies_svy_ques_data_v
493: SET ANSWER_COUNT = anscountfree_rec.answer_count
494: where survey_id = anscountfree_rec.survey_id
495: and survey_deployment_id = anscountfree_rec.survey_deployment_id
496: and dscript_id = anscountfree_rec.dscript_id

Line 504: UPDATE ies_svy_ques_data_v

500: and lookup_id = anscountfree_rec.lookup_id;
501: END LOOP;
502:
503: FOR anscount_rec IN anscount_cur LOOP
504: UPDATE ies_svy_ques_data_v
505: SET ANSWER_COUNT = anscount_rec.answer_count
506: where survey_id = anscount_rec.survey_id
507: and survey_deployment_id = anscount_rec.survey_deployment_id
508: and dscript_id = anscount_rec.dscript_id