BEGIN

DECLARE cKey, cVerNo  INTEGER ;

SET  (cKey, cVersion) =
 (SELECT  max(c.KEY), max(c.VERSION) FROM schemaA.COLLECTION c WHERE c.YEAR = @cYear);

SELECT count(*) FROM schemaA.tbl_Fact tf WHERE tf.CKEY = cKey AND   tf.CVERSION = cVersion;

SELECT count(*) FROM schemaA.tbl_Scope ts WHERE ts.CKEY = cKey AND ts.CVERSION = cVersion;

END;