APPS.AMS_CTD_UTIL_PKG dependencies on IES_SVY_SURVEYS_ALL

Line 83: WHERE TABLE_NAME='IES_SVY_SURVEYS_ALL'

79: CURSOR C_CHECK_SURVEY_TABLE (p_table_owner varchar2)
80: IS
81: /* SELECT 'Y' -- fix for bug 15876260
82: FROM ALL_TAB_COLUMNS
83: WHERE TABLE_NAME='IES_SVY_SURVEYS_ALL'
84: AND COLUMN_NAME = 'SURVEY_TYPE'
85: AND OWNER = p_table_owner; */
86:
87: SELECT 'Y'

Line 89: WHERE syn.synonym_name = 'IES_SVY_SURVEYS_ALL'

85: AND OWNER = p_table_owner; */
86:
87: SELECT 'Y'
88: FROM user_synonyms syn, dba_tab_columns col
89: WHERE syn.synonym_name = 'IES_SVY_SURVEYS_ALL'
90: AND col.owner = syn.table_owner
91: AND col.table_name = syn.table_name
92: --AND col.owner = p_table_owner
93: AND col.column_name = 'SURVEY_TYPE';

Line 98: from ies_svy_surveys_all svy,

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