
# Busca el monto pagado al colector
     SELECT sum(debito-credito) INTO busca_datos.imp_colect FROM cgtb00004
     WHERE (cuenta_no = "1161-01" and status_t is null and
           fecha <= fecha_final and cod_sec = cod_sec and
           num_doc = orden) 
