DBA Data[Home] [Help]

APPS.AMS_CTD_UTIL_PKG dependencies on IES_SVY_CYCLES_ALL

Line 89: IES_SVY_CYCLES_ALL cyc,

85: CURSOR C_GET_SURVEY_TYPE
86: IS
87: select svy.survey_type
88: from ies_svy_surveys_all svy,
89: IES_SVY_CYCLES_ALL cyc,
90: IES_SVY_DEPLYMENTS_ALL dep
91: where dep.survey_deployment_id = p_deployment_id
92: and dep.survey_cycle_id = cyc.survey_cycle_id
93: and cyc.survey_id = svy.survey_id;