APPS.AMS_CTD_UTIL_PKG dependencies on AMS_SOURCE_CODES
Line 187: select source_code_id from ams_source_codes
183: IS
184:
185: cursor c_get_source_code_id
186: is 187: select source_code_id from ams_source_codes 188: where arc_source_code_for = 'CSCH'
189: and source_code_for_id = p_schedule_id
190: and active_flag='Y';
191: