DBA Data[Home] [Help]

APPS.BIM_RESPONSE_IMPORT_PUB dependencies on AMS_SOURCE_CODES

Line 91: FROM AMS_SOURCE_CODES

87: AND lookup_code = l_cur_res_code;
88:
89: CURSOR c_source_code(l_cur_source_code Varchar2) IS
90: SELECT source_code
91: FROM AMS_SOURCE_CODES
92: WHERE source_code = l_cur_source_code ;
93:
94: CURSOR c_country_code(l_cur_country_code Varchar2) IS
95: SELECT country_code

Line 403: FROM AMS_SOURCE_CODES

399: FROM dual;
400:
401: CURSOR c_source_code_ids (c_source_code IN Varchar2) IS
402: SELECT source_code_id ,source_code_for_id ,arc_source_code_for
403: FROM AMS_SOURCE_CODES
404: WHERE source_code = c_source_code;
405:
406: CURSOR c_region_code (c_country_code IN Varchar2) IS
407: SELECT area2_code