DBA Data[Home] [Help]

APPS.IES_SURVEY_SUMMARY dependencies on IES_SVY_LIST_SUMMARY_V

Line 637: FROM ies_svy_list_summary_v

633: FOR replist_rec IN replist_cur LOOP
634: begin
635: select 1
636: INTO l_exist_flag
637: FROM ies_svy_list_summary_v
638: WHERE list_header_id = replist_rec.list_header_id
639: and survey_deployment_id = replist_rec.survey_deployment_id
640: and response_date = replist_rec.response_collected_date
641: and survey_cycle_id = replist_rec.survey_cycle_id

Line 649: INSERT INTO ies_svy_list_summary_v

645: l_exist_flag := 0;
646: end;
647:
648: if l_exist_flag = 0 then
649: INSERT INTO ies_svy_list_summary_v
650: (survey_id,
651: survey_name,
652: survey_cycle_id,
653: survey_cycle_name,

Line 678: update ies_svy_list_summary_v

674: 0,
675: replist_rec.no_of_responses,
676: 0);
677: else
678: update ies_svy_list_summary_v
679: set no_responses = replist_rec.no_of_responses
680: WHERE
681: list_header_id = replist_rec.list_header_id
682: and survey_deployment_id = replist_rec.survey_deployment_id