APPS.IBY_FNDCPT_TRXN_PUB dependencies on IBY_DEBIT_AUTHORIZATIONS

Line 5316: FROM iby_debit_authorizations

5312: /* fetch the debit_auth_id for bank_accounts */
5313:
5314: BEGIN
5315: SELECT MAX(debit_authorization_id) into l_debit_auth_id
5316: FROM iby_debit_authorizations
5317: WHERE external_bank_account_use_id = l_settlement_trxn_rec.payer_instr_assignment_id
5318: AND nvl(auth_cancel_date,sysdate+10) >= sysdate
5319: -- AND auth_cancel_date is null
5320: AND debit_auth_flag = 'Y'

Line 5332: FROM iby_debit_authorizations

5328:
5329: IF (NOT l_debit_auth_id iS NULL)
5330: THEN
5331: SELECT payment_type_code into l_payment_type_code
5332: FROM iby_debit_authorizations
5333: WHERE debit_authorization_id = l_debit_auth_id;
5334:
5335: IF (l_payment_type_code = 'OOFF') THEN
5336: l_Trxn_Tab(indx).seq_type := l_payment_type_code;