APPS.AMS_CTD_UTIL_PKG dependencies on IES_SVY_SURVEYS_ALL

Line 81: WHERE TABLE_NAME='IES_SVY_SURVEYS_ALL'

77: CURSOR C_CHECK_SURVEY_TABLE (p_table_owner varchar2)
78: IS
79: SELECT 'Y'
80: FROM ALL_TAB_COLUMNS
81: WHERE TABLE_NAME='IES_SVY_SURVEYS_ALL'
82: AND COLUMN_NAME = 'SURVEY_TYPE'
83: AND OWNER = p_table_owner;
84:
85: CURSOR C_GET_SURVEY_TYPE

Line 88: from ies_svy_surveys_all svy,

84:
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