APPS.AMS_LISTSOURCETYPE_PVT dependencies on AMS_LOOKUPS

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

1026: x_return_status OUT NOCOPY VARCHAR2
1027: )
1028: IS
1029: l_import_type VARCHAR2(30);
1030: CURSOR c_import_type(code IN VARCHAR2) IS SELECT lookup_code FROM ams_lookups
1031: WHERE lookup_type = 'AMS_IMPORT_TYPE' and enabled_flag='Y'
1032: AND lookup_code = code;
1033:
1034: cursor c_viewname(code in varchar2) is