APPS.IBY_FNDCPT_VLD_PUB dependencies on IBY_BATCHES_ALL

Line 73: from iby_batches_all b,

69: tc.instr_owner_postalcode,
70: tc.instr_owner_country,
71: tc.shipfromzip,
72: tc.shiptozip
73: from iby_batches_all b,
74: iby_trxn_summaries_all ts,
75: iby_trxn_core tc
76: where b.mbatchid = P_MBATCH_ID
77: and b.mbatchid = ts.mbatchid

Line 106: from iby_batches_all

102:
103: -- Validate BATCH NAME
104: select length(batchid)
105: into l_batchid_size
106: from iby_batches_all
107: where mbatchid = P_MBATCH_ID;
108:
109: if l_batchid_size > 8 then
110: x_return_status := FND_API.G_RET_STS_ERROR;

Line 235: from iby_batches_all b,

231: tc.instr_owner_postalcode,
232: tc.instr_owner_country,
233: tc.shipfromzip,
234: tc.shiptozip
235: from iby_batches_all b,
236: iby_trxn_summaries_all ts,
237: iby_trxn_core tc
238: where b.mbatchid = P_MBATCH_ID
239: and b.mbatchid = ts.mbatchid

Line 289: iby_batches_all

285: INTO
286: l_payee_id,
287: l_batch_close_date
288: FROM
289: iby_batches_all
290: WHERE
291: mbatchid = P_MBATCH_ID
292: ;
293:

Line 314: -- from iby_batches_all

310: ;
311: /* this sql statement has been replaced by the one below */
312: --select count(*)
313: -- into l_batch_count
314: -- from iby_batches_all
315: -- where mpayeeid = l_payee_id
316: -- and trunc(batchclosedate) = l_batch_close_date;
317:
318: /*

Line 332: IBY_BATCHES_ALL batch

328: FROM
329: IBY_BEP_ACCT_OPT_VALS val,
330: IBY_BEPKEYS key,
331: IBY_PAYEE payee,
332: IBY_BATCHES_ALL batch
333: WHERE
334: val.account_option_code = 'SEC_CODE'
335: AND
336: val.account_option_value = l_security_code

Line 541: update iby_batches_all

537: close level2_trxn;
538:
539: -- Bug 4243738: Added
540: if x_return_status = FND_API.G_RET_STS_SUCCESS then
541: update iby_batches_all
542: set SENTCOUNTERDAILY = l_batch_count
543: where mbatchid = P_MBATCH_ID;
544: end if;
545:

Line 580: from iby_batches_all b,

576: tc.instr_owner_postalcode,
577: tc.instr_owner_country,
578: tc.shipfromzip,
579: tc.shiptozip
580: from iby_batches_all b,
581: iby_trxn_summaries_all ts,
582: iby_trxn_core tc
583: where b.mbatchid = P_MBATCH_ID
584: and b.mbatchid = ts.mbatchid

Line 613: from iby_batches_all

609:
610: -- Validate BATCH NAME
611: select length(batchid)
612: into l_batchid_size
613: from iby_batches_all
614: where mbatchid = P_MBATCH_ID;
615:
616: if l_batchid_size > 8 then
617: x_return_status := FND_API.G_RET_STS_ERROR;