[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;
232: l_deploy_date,
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
321:
322: cursor deployments is
323: select survey_deployment_id,
324: list_header_id
325: from ies_svy_deplyments_v
326: where survey_cycle_id = p_cycle_id;
327:
328: begin
329:
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,
417: ies_question_data iqd,
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,
460: ies_question_data iqd,
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
606: WHERE iscv.survey_cycle_id = P_CYCLE_ID