DBA Data[Home] [Help]

APPS.IES_SVY_CREATE_INIT_RECORDS dependencies on IES_ANSWERS

Line 75: ies_answers ia

71: ies_panels ip,
72: ies_questions iq,
73: ies_question_types iqt,
74: ies_lookups il,
75: ies_answers ia
76: WHERE issv.dscript_id = ids.dscript_id
77: AND ids.active_status = 1
78: AND ids.dscript_id = ip.dscript_id
79: AND ip.active_status = 1

Line 123: AND not exists (select '*' from ies_answers where ies_answers.lookup_id = iq.lookup_id )

119: AND ids.dscript_id = ip.dscript_id
120: AND ids.active_status = 1
121: AND ip.panel_id = iq.panel_id
122: AND ip.active_status = 1
123: AND not exists (select '*' from ies_answers where ies_answers.lookup_id = iq.lookup_id )
124: AND iq.question_type_id = iqt.question_type_id
125: AND iq.active_status = 1
126: AND isdv.survey_cycle_id = iscv.survey_cycle_id
127: AND isdv.survey_deployment_id = p_deployment_id