APPS.IBY_QUERYCC_PKG dependencies on IBY_BATCHES_ALL

Line 12: loc_vpsid iby_batches_all.VPSBatchID%TYPE;

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:

Line 19: FROM iby_batches_all

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;

Line 168: loc_stat iby_batches_all.BatchStatus%TYPE;

164:
165:
166: AS
167:
168: loc_stat iby_batches_all.BatchStatus%TYPE;
169: loc_viby_bid iby_batches_all.VPSBatchID%TYPE;
170:
171: CURSOR b1 IS
172: SELECT BatchStatus, VPSBatchID

Line 169: loc_viby_bid iby_batches_all.VPSBatchID%TYPE;

165:
166: AS
167:
168: loc_stat iby_batches_all.BatchStatus%TYPE;
169: loc_viby_bid iby_batches_all.VPSBatchID%TYPE;
170:
171: CURSOR b1 IS
172: SELECT BatchStatus, VPSBatchID
173: FROM iby_batches_all

Line 173: FROM iby_batches_all

169: loc_viby_bid iby_batches_all.VPSBatchID%TYPE;
170:
171: CURSOR b1 IS
172: SELECT BatchStatus, VPSBatchID
173: FROM iby_batches_all
174: WHERE BatchID = batch_id_in
175: AND payeeid = merchant_id_in
176: ORDER BY BatchCloseDate DESC;
177: