APPS.AMS_CTD_UTIL_PKG dependencies on AMS_SOURCE_CODES
Line 177: select source_code_id from ams_source_codes
173: IS
174:
175: cursor c_get_source_code_id
176: is 177: select source_code_id from ams_source_codes 178: where arc_source_code_for = 'CSCH'
179: and source_code_for_id = p_schedule_id
180: and active_flag='Y';
181: