[Home] [Help]
85: l_list_name,
86: l_deploy_date,
87: l_response_end_date,
88: l_deployment_name
89: from ies_svy_deplyments_v isdv, ams_list_headers_all alsh, ies_svy_cycles_v iscv, ies_svy_surveys_v issv
90: where isdv.survey_deployment_id = p_deployment_id
91: and isdv.list_header_id = alsh.list_header_id(+)
92: and isdv.survey_cycle_id = iscv.survey_cycle_id
93: and iscv.survey_id = issv.survey_id;
233: l_response_end_date,
234: l_deployment_name,
235: l_deployment_status
236: from ies_svy_deplyments_v isdv,
237: ies_svy_cycles_v iscv,
238: ies_svy_surveys_v issv
239: where survey_deployment_id = p_deployment_id
240: and isdv.survey_cycle_id = iscv.survey_cycle_id
241: and iscv.survey_id = issv.survey_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,
417: ies_question_data iqd,
418: ies_questions iq,
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,
460: ies_question_data iqd,
461: ies_questions iq,
537:
538: SELECT count(question_id)
539: INTO l_ques_type_count
540: FROM IES_SVY_SURVEYS_V a,
541: IES_SVY_CYCLES_V b,
542: IES_DEPLOYED_SCRIPTS c,
543: IES_PANELS d,
544: IES_QUESTIONS e
545: WHERE b.survey_cycle_id = p_cycle_id
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,
604: ies_ams_list_entries_v iale,
605: ies_ams_list_headers_v ialh