APPS.AMS_CTD_UTIL_PKG dependencies on IES_SVY_CYCLES_ALL

Line 99: IES_SVY_CYCLES_ALL cyc,

95: CURSOR C_GET_SURVEY_TYPE
96: IS
97: select svy.survey_type
98: from ies_svy_surveys_all svy,
99: IES_SVY_CYCLES_ALL cyc,
100: IES_SVY_DEPLYMENTS_ALL dep
101: where dep.survey_deployment_id = p_deployment_id
102: and dep.survey_cycle_id = cyc.survey_cycle_id
103: and cyc.survey_id = svy.survey_id;