8: viby_id OUT NOCOPY VARCHAR2)
9:
10: IS
11:
12: loc_vpsid iby_batches_all.VPSBatchID%TYPE;
13: BEGIN
14:
15: loc_vpsid := NULL;
16:
15: loc_vpsid := NULL;
16:
17: SELECT distinct VPSBatchID
18: INTO loc_vpsid
19: FROM iby_batches_all
20: WHERE payeeid = merchant_id_in AND
21: BatchID = batch_id_in AND
22: bepid = vendor_id_in AND
23: bepkey = vendor_key_in;
162:
163:
164: AS
165:
166: loc_stat iby_batches_all.BatchStatus%TYPE;
167: loc_viby_bid iby_batches_all.VPSBatchID%TYPE;
168:
169: CURSOR b1 IS
170: SELECT BatchStatus, VPSBatchID
163:
164: AS
165:
166: loc_stat iby_batches_all.BatchStatus%TYPE;
167: loc_viby_bid iby_batches_all.VPSBatchID%TYPE;
168:
169: CURSOR b1 IS
170: SELECT BatchStatus, VPSBatchID
171: FROM iby_batches_all
167: loc_viby_bid iby_batches_all.VPSBatchID%TYPE;
168:
169: CURSOR b1 IS
170: SELECT BatchStatus, VPSBatchID
171: FROM iby_batches_all
172: WHERE BatchID = batch_id_in
173: AND payeeid = merchant_id_in
174: ORDER BY BatchCloseDate DESC;
175: