Version 8.0.a UO custom-made grant status codes messed up the query. Use a NVL function to query on the grant status, if NULL then default to A(ctive). Originally written for OWAG then 5.2.a was requested by other institutions.