Page History

CREATE OR REPLACE PROCEDURE CREDITOPY.PR_COMISIONES_CABAL_QR(IdTxDestino IN VARCHAR2,
		                                               			codReturn OUT NUMBER,
		                                                		txtReturn OUT VARCHAR2,
		                                                		valorComision OUT NUMBER) IS 
		                                                	
		                                                		
	VR_VALOR_COMISION NUMBER(15,2);	                                                		
BEGIN
	codReturn := 1;
	txtReturn := 'NO CORRESPONDE EL REQUEST';


	SELECT c.IMPORTE_DTO INTO VR_VALOR_COMISION FROM CREDITOPY.CUPONES c WHERE c.NUMERO_CUPON = IdTxDestino; 
	--SELECT c.IMPORTE_DTO INTO VR_VALOR_COMISION FROM CREDITOPY.CUPONES c WHERE c.FECHA_CUPON BETWEEN to_date('151220220000','ddmmyyyyhh24mi') AND to_date('020220230000','ddmmyyyyhh24mi') AND c.NUMERO_CUPON = 1449358386; 

	codReturn := 0;
	txtReturn := 'SUCCESS';
	valorComision := VR_VALOR_COMISION;

END;