APPS.IBY_FNDCPT_VLD_PUB dependencies on IBY_BATCHES_ALL

Line 119: from iby_batches_all b,

115: tc.instr_owner_postalcode,
116: tc.instr_owner_country,
117: tc.shipfromzip,
118: tc.shiptozip
119: from iby_batches_all b,
120: iby_trxn_summaries_all ts,
121: iby_trxn_core tc
122: where b.mbatchid = P_MBATCH_ID
123: and b.mbatchid = ts.mbatchid

Line 152: from iby_batches_all

148:
149: -- Validate BATCH NAME
150: select length(batchid)
151: into l_batchid_size
152: from iby_batches_all
153: where mbatchid = P_MBATCH_ID;
154:
155: if l_batchid_size > 8 then
156: x_return_status := FND_API.G_RET_STS_ERROR;

Line 282: from iby_batches_all b,

278: tc.instr_owner_postalcode,
279: tc.instr_owner_country,
280: tc.shipfromzip,
281: tc.shiptozip
282: from iby_batches_all b,
283: iby_trxn_summaries_all ts,
284: iby_trxn_core tc
285: where b.mbatchid = P_MBATCH_ID
286: and b.mbatchid = ts.mbatchid

Line 336: iby_batches_all

332: INTO
333: l_payee_id,
334: l_batch_close_date
335: FROM
336: iby_batches_all
337: WHERE
338: mbatchid = P_MBATCH_ID
339: ;
340:

Line 376: -- from iby_batches_all

372: ;
373: /* this sql statement has been replaced by the one below */
374: --select count(*)
375: -- into l_batch_count
376: -- from iby_batches_all
377: -- where mpayeeid = l_payee_id
378: -- and trunc(batchclosedate) = l_batch_close_date;
379:
380: /*

Line 395: IBY_BATCHES_ALL batch

391: FROM
392: IBY_BEP_ACCT_OPT_VALS val,
393: IBY_BEPKEYS bepkey,
394: IBY_PAYEE payee,
395: IBY_BATCHES_ALL batch
396: WHERE
397: val.account_option_code = 'SEC_CODE'
398: AND
399: val.account_option_value = l_security_code

Line 605: update iby_batches_all

601: close level2_trxn;
602:
603: -- Bug 4243738: Added
604: if x_return_status = FND_API.G_RET_STS_SUCCESS then
605: update iby_batches_all
606: set SENTCOUNTERDAILY = l_batch_count
607: where mbatchid = P_MBATCH_ID;
608: end if;
609:

Line 645: from iby_batches_all b,

641: tc.instr_owner_postalcode,
642: tc.instr_owner_country,
643: tc.shipfromzip,
644: tc.shiptozip
645: from iby_batches_all b,
646: iby_trxn_summaries_all ts,
647: iby_trxn_core tc
648: where b.mbatchid = P_MBATCH_ID
649: and b.mbatchid = ts.mbatchid

Line 678: from iby_batches_all

674:
675: -- Validate BATCH NAME
676: select length(batchid)
677: into l_batchid_size
678: from iby_batches_all
679: where mbatchid = P_MBATCH_ID;
680:
681: if l_batchid_size > 8 then
682: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1021: from iby_batches_all b

1017:
1018: -- Cursor for settlement records.
1019: cursor c_settle_trxns is
1020: select ts.trxnmid
1021: from iby_batches_all b
1022: ,iby_trxn_summaries_all ts
1023: where b.mbatchid = P_MBATCH_ID
1024: and b.mbatchid = ts.mbatchid ;
1025:

Line 1412: FROM iby_batches_all b ,

1408: -- Cursor for settlement records.
1409: CURSOR c_settle_trxns
1410: IS
1411: SELECT ts.trxnmid
1412: FROM iby_batches_all b ,
1413: iby_trxn_summaries_all ts
1414: WHERE b.mbatchid = P_MBATCH_ID
1415: AND b.mbatchid = ts.mbatchid ;
1416: -- Cursor to retrieve the certain mandate params.