APPS.IBY_VALIDATIONSETS_PUB dependencies on CE_BANK_BRANCHES_V

Line 80: bank_home_country CE_BANK_BRANCHES_V.bank_home_country%TYPE,

76: ext_bank_acct_tbl externalBankAcctTabType;
77:
78: TYPE internalBankAcctType IS RECORD (
79: internal_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE,
80: bank_home_country CE_BANK_BRANCHES_V.bank_home_country%TYPE,
81: country CE_BANK_BRANCHES_V.country%TYPE
82: );
83: --
84: TYPE internalBankAcctTabType IS TABLE OF internalBankAcctType

Line 81: country CE_BANK_BRANCHES_V.country%TYPE

77:
78: TYPE internalBankAcctType IS RECORD (
79: internal_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE,
80: bank_home_country CE_BANK_BRANCHES_V.bank_home_country%TYPE,
81: country CE_BANK_BRANCHES_V.country%TYPE
82: );
83: --
84: TYPE internalBankAcctTabType IS TABLE OF internalBankAcctType
85: INDEX BY BINARY_INTEGER;

Line 648: l_country CE_BANK_BRANCHES_V.country%TYPE;

644: l_country_code IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE;
645: l_foreign_pmts_ok_flag IBY_EXT_BANK_ACCOUNTS_V.foreign_payment_use_flag%TYPE;
646:
647: l_int_bank_acct_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
648: l_country CE_BANK_BRANCHES_V.country%TYPE;
649: l_bank_home_country CE_BANK_BRANCHES_V.bank_home_country%TYPE;
650:
651: l_payee_id IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE;
652: l_payee_party_id IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE;

Line 649: l_bank_home_country CE_BANK_BRANCHES_V.bank_home_country%TYPE;

645: l_foreign_pmts_ok_flag IBY_EXT_BANK_ACCOUNTS_V.foreign_payment_use_flag%TYPE;
646:
647: l_int_bank_acct_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
648: l_country CE_BANK_BRANCHES_V.country%TYPE;
649: l_bank_home_country CE_BANK_BRANCHES_V.bank_home_country%TYPE;
650:
651: l_payee_id IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE;
652: l_payee_party_id IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE;
653:

Line 727: p_country CE_BANK_BRANCHES_V.country%TYPE

723: p_int_bank_acct_id IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
724: p_payment_format_code IBY_PAYMENT_PROFILES.payment_format_code%TYPE,
725: p_bepid IBY_PAYMENT_PROFILES.bepid%TYPE,
726: p_transmit_protocol_code IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE,
727: p_country CE_BANK_BRANCHES_V.country%TYPE
728: )
729: IS
730: SELECT DISTINCT
731: p_document_payable_id,

Line 958: FROM CE_BANK_ACCOUNTS cba, CE_BANK_BRANCHES_V cb

954: cb.bank_home_country
955: INTO l_int_bank_acct_id,
956: l_country,
957: l_bank_home_country
958: FROM CE_BANK_ACCOUNTS cba, CE_BANK_BRANCHES_V cb
959: WHERE cba.bank_branch_id = cb.branch_party_id
960: AND cba.bank_account_id = l_docs_tab(i).int_bank_acct_id;
961:
962:

Line 2635: CE_BANK_BRANCHES_V iba_bnk_branch,

2631: HZ_PARTIES payee,
2632: HZ_PARTY_SITES payeesite,
2633: HZ_LOCATIONS payee_loc,
2634: CE_BANK_ACCOUNTS iba,
2635: CE_BANK_BRANCHES_V iba_bnk_branch,
2636: IBY_EXT_BANK_ACCOUNTS_INT_V eba,
2637: CE_BANK_BRANCHES_V eba_bank_branch,
2638: IBY_DELIVERY_CHANNELS_B del_chn
2639: WHERE

Line 2637: CE_BANK_BRANCHES_V eba_bank_branch,

2633: HZ_LOCATIONS payee_loc,
2634: CE_BANK_ACCOUNTS iba,
2635: CE_BANK_BRANCHES_V iba_bnk_branch,
2636: IBY_EXT_BANK_ACCOUNTS_INT_V eba,
2637: CE_BANK_BRANCHES_V eba_bank_branch,
2638: IBY_DELIVERY_CHANNELS_B del_chn
2639: WHERE
2640: docs.document_payable_id = p_doc_id
2641: AND docs.legal_entity_id = payer.party_legal_id

Line 3010: CE_BANK_BRANCHES_V iba_bnk_branch,

3006: /* Payer */
3007: IBY_PP_FIRST_PARTY_V payer,
3008: /* Payer bank */
3009: CE_BANK_ACCOUNTS iba,
3010: CE_BANK_BRANCHES_V iba_bnk_branch,
3011: /* Payee */
3012: HZ_PARTIES payee,
3013: HZ_LOCATIONS payee_loc,
3014: /* Payee bank */

Line 6974: CE_BANK_BRANCHES_V iba_bnk_branch,

6970: IBY_PP_FIRST_PARTY_V payer,
6971: HZ_PARTIES payee,
6972: HZ_PARTY_SITES payeesite,
6973: CE_BANK_ACCOUNTS iba,
6974: CE_BANK_BRANCHES_V iba_bnk_branch,
6975: IBY_EXT_BANK_ACCOUNTS eba,
6976: IBY_ACCOUNT_OWNERS ow,
6977: HZ_PARTIES op,
6978: IBY_SYS_SECURITY_SUBKEYS baek,

Line 6982: CE_BANK_BRANCHES_V eba_bank_branch,

6978: IBY_SYS_SECURITY_SUBKEYS baek,
6979: IBY_SECURITY_SEGMENTS baes,
6980: IBY_SYS_SECURITY_SUBKEYS baik,
6981: IBY_SECURITY_SEGMENTS bais,
6982: CE_BANK_BRANCHES_V eba_bank_branch,
6983: IBY_DELIVERY_CHANNELS_B del_chn,
6984:
6985: /*
6986: * Fix for bug 5997016: