eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_FNDCPT_VLD_PUB dependencies on CE_BANK_BRANCHES_V

Line 879: l_swift_code ce_bank_branches_v.eft_swift_code%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:
883: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 912: ce_bank_branches_v bbv

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'
916: AND eb.branch_id = bbv.branch_party_id

Line 1085: l_swift_code ce_bank_branches_v.eft_swift_code%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
1089:

Line 1143: ce_bank_branches_v bbv

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'
1147: AND eb.branch_id = bbv.branch_party_id