APPS.IES_SURVEY_SUMMARY dependencies on IES_SVY_RESP_ENTRIES_V

Line 103: from ies_svy_resp_entries_v

99: into
100: l_total_no_responses_recd,
101: l_total_no_abandoned,
102: l_total_no_aborted
103: from ies_svy_resp_entries_v
104: where survey_deployment_id = p_deployment_id;
105:
106:
107: select count(*),

Line 252: from ies_svy_resp_entries_v

248: into
249: l_total_no_responses_recd,
250: l_total_no_abandoned,
251: l_total_no_aborted
252: from ies_svy_resp_entries_v
253: where survey_deployment_id = p_deployment_id;
254:
255: open cdepid;
256: fetch cdepid into l_deployment_id;

Line 412: ies_svy_resp_entries_v isre,

408: iqd.lookup_id,
409: 0 answer_id,
410: count(decode(question_type, 'Checkbox', (decode(freeform_string, '1', 1, '0', 0)), 1)) answer_count
411: FROM
412: ies_svy_resp_entries_v isre,
413: ies_svy_deplyments_v isdv,
414: ies_svy_cycles_v iscv,
415: ies_svy_surveys_v issv,
416: ies_deployed_scripts ids,

Line 455: ies_svy_resp_entries_v isre,

451: iqd.lookup_id,
452: ia.answer_id,
453: count(decode(question_type, 'Checkbox', (decode(freeform_string, '1', 1, '0', 0)), 1)) answer_count
454: from
455: ies_svy_resp_entries_v isre,
456: ies_svy_deplyments_v isdv,
457: ies_svy_cycles_v iscv,
458: ies_svy_surveys_v issv,
459: ies_deployed_scripts ids,

Line 599: ies_svy_resp_entries_v isrv,

595: iale.list_header_id,
596: ialh.list_name,
597: count(distinct isrv.survey_list_entry_id) no_of_responses
598: FROM
599: ies_svy_resp_entries_v isrv,
600: ies_svy_list_entries_v islev,
601: ies_svy_cycles_v iscv,
602: ies_svy_deplyments_v isdv,
603: ies_svy_surveys_v issv,