APPS.AMS_LISTIMPORT_PVT dependencies on AMS_LOOKUPS

Line 922: select 'Y' from ams_lookups where lookup_type = 'AMS_VEHICLE_RESPONSE_CODE'

918: AND load_status in ('ACTIVE','RELOAD');
919:
920:
921: CURSOR vehicle_code_exists (x_vehicle_code varchar) IS
922: select 'Y' from ams_lookups where lookup_type = 'AMS_VEHICLE_RESPONSE_CODE'
923: and lookup_code = x_vehicle_code and enabled_flag = 'Y';
924:
925:
926: CURSOR resource_exists (x_sa_email_address varchar) IS