APPS.IBY_VALIDATIONSETS_PUB dependencies on CE_BANK_ACCOUNTS

Line 79: internal_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE,

75:
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: --

Line 647: l_int_bank_acct_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;

643: l_end_date IBY_EXT_BANK_ACCOUNTS_V.end_date%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;

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 2634: CE_BANK_ACCOUNTS iba,

2630: IBY_PP_FIRST_PARTY_V payer,
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

Line 3009: CE_BANK_ACCOUNTS iba,

3005: IBY_DOCUMENT_LINES lines,
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,

Line 3122: CE_BANK_ACCOUNTS payer_bank_acc

3118:
3119: FROM
3120: IBY_PAYMENTS_ALL pay,
3121: IBY_PP_FIRST_PARTY_V payer,
3122: CE_BANK_ACCOUNTS payer_bank_acc
3123: WHERE
3124: pay.payment_id = p_pay_id
3125: AND
3126: pay.legal_entity_id = payer.party_legal_id

Line 6973: CE_BANK_ACCOUNTS iba,

6969: IBY_DOCS_PAYABLE_ALL docs,
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,