APPS.AMS_LIST_SRC_TYPES_PKG dependencies on AMS_LOOKUPS

Line 36: CURSOR c_import_type(code IN VARCHAR2) IS SELECT lookup_code FROM ams_lookups

32: l_import_type VARCHAR2(30);
33: CURSOR c IS SELECT rowid FROM ams_list_src_types
34: WHERE list_source_type_id = x_list_source_type_id;
35:
36: CURSOR c_import_type(code IN VARCHAR2) IS SELECT lookup_code FROM ams_lookups
37: WHERE lookup_type = 'AMS_IMPORT_TYPE' and enabled_flag='Y'
38: AND lookup_code = code;
39: BEGIN
40: if x_import_type is not null or

Line 231: CURSOR c_import_type(code IN VARCHAR2) IS SELECT lookup_code FROM ams_lookups

227: x_last_update_login IN NUMBER,
228: x_BASED_ON_TCA_FLAG IN varchar2
229: ) IS
230: l_import_type VARCHAR2(30);
231: CURSOR c_import_type(code IN VARCHAR2) IS SELECT lookup_code FROM ams_lookups
232: WHERE lookup_type = 'AMS_IMPORT_TYPE' and enabled_flag='Y'
233: AND lookup_code = code;
234: BEGIN
235: if x_import_type is not null or