DBA Data[Home] [Help]

APPS.IBY_FNDCPT_VLD_PUB dependencies on IBY_EXT_BANK_ACCOUNTS

Line 878: l_iban iby_ext_bank_accounts.iban%TYPE;

874: l_creditor_legal_entity_id iby_debit_authorizations.creditor_legal_entity_id%TYPE;
875: l_creditor_identifier iby_debit_authorizations.creditor_identifier%TYPE;
876: l_cust_addr_id iby_debit_authorizations.cust_addr_id%TYPE;
877: l_payee_address VARCHAR2(4000);
878: l_iban iby_ext_bank_accounts.iban%TYPE;
879: l_swift_code ce_bank_branches_v.eft_swift_code%TYPE;
880:
881: BEGIN
882:

Line 911: iby_ext_bank_accounts eb,

907:
908: SELECT eb.iban , bbv.eft_swift_code into
909: l_iban , l_swift_code
910: FROM iby_pmt_instr_uses_all uses,
911: iby_ext_bank_accounts eb,
912: ce_bank_branches_v bbv
913: WHERE uses.instrument_id = eb.ext_bank_account_id
914: AND uses.payment_flow = 'FUNDS_CAPTURE'
915: AND uses.instrument_type = 'BANKACCOUNT'

Line 1084: l_iban iby_ext_bank_accounts.iban%TYPE;

1080: l_creditor_le_name iby_debit_authorizations.creditor_le_name%TYPE;
1081: l_payee_address VARCHAR2(4000);
1082: l_le_name VARCHAR2(4000);
1083: l_external_bank_account_use_id iby_debit_authorizations.external_bank_account_use_id%TYPE;
1084: l_iban iby_ext_bank_accounts.iban%TYPE;
1085: l_swift_code ce_bank_branches_v.eft_swift_code%TYPE;
1086:
1087:
1088: BEGIN

Line 1142: iby_ext_bank_accounts eb,

1138: BEGIN
1139: SELECT eb.iban , bbv.eft_swift_code into
1140: l_iban , l_swift_code
1141: FROM iby_pmt_instr_uses_all uses,
1142: iby_ext_bank_accounts eb,
1143: ce_bank_branches_v bbv
1144: WHERE uses.instrument_id = eb.ext_bank_account_id
1145: AND uses.payment_flow = 'FUNDS_CAPTURE'
1146: AND uses.instrument_type = 'BANKACCOUNT'