CREATE PROCEDURE sp_Api5_AppFac_pvtCajaEstado
    @sucursal VARCHAR(10),
    @caja VARCHAR(10)
AS
BEGIN
    SET NOCOUNT ON;

    SELECT pvtMovCajaEnc.correlativo AS cierre,
           pvtMovCajaEnc.loging AS host,
           pvtMovCajaEnc.correlativocierre
    FROM pvtMovCajaEnc
    INNER JOIN pvtCajas ON pvtMovCajaEnc.correlativo = pvtCajas.cierre
    WHERE tipo = 1 AND estado = 0
      AND pvtCajas.codigo = @caja
      AND pvtCajas.sucursal = @sucursal
END