APPS.AMS_MET_TPL_ASSOC_PVT dependencies on AMS_LOOKUPS

Line 940: SELECT 1 FROM ams_lookups

936: SELECT 1 FROM ams_custom_setups_vl
937: WHERE custom_setup_id = p_used_by_id;
938:
939: CURSOR c_check_object_type(p_used_by_code VARCHAR2) IS
940: SELECT 1 FROM ams_lookups
941: WHERE lookup_code = p_used_by_code
942: AND lookup_type = 'AMS_SYS_ARC_QUALIFIER';
943:
944: l_dummy NUMBER;