DBA Data[Home] [Help]

APPS.IBY_VALIDATIONSETS_PUB dependencies on CE_BANK_BRANCHES_V

Line 601: CE_BANK_BRANCHES_V iba_branch,

597: eba.foreign_payment_use_flag foreign_pmts_allowed_flag
598: FROM
599: IBY_DOCS_PAYABLE_ALL docs,
600: CE_BANK_ACCOUNTS iba,
601: CE_BANK_BRANCHES_V iba_branch,
602: IBY_EXT_BANK_ACCOUNTS_V eba
603: WHERE
604: docs.payment_service_request_id = p_pay_service_request_id AND
605: docs.internal_bank_account_id = iba.bank_account_id AND

Line 644: CE_BANK_BRANCHES_V iba_branch

640: IBY_ACCT_PMT_PROFILES_B acct_prof,
641: IBY_TRANSMIT_CONFIGS_B txconf,
642: IBY_TRANSMIT_PROTOCOLS_B txproto,
643: CE_BANK_ACCOUNTS iba,
644: CE_BANK_BRANCHES_V iba_branch
645: WHERE
646: docs.document_payable_id = p_document_payable_id
647: AND docs.internal_bank_account_id = iba.bank_account_id
648: AND iba_branch.branch_party_id = iba.bank_branch_id

Line 1884: CE_BANK_BRANCHES_V iba_bnk_branch,

1880: IBY_DOCS_PAYABLE_ALL docs,
1881: IBY_PP_FIRST_PARTY_V payer,
1882: HZ_PARTIES payee,
1883: CE_BANK_ACCOUNTS iba,
1884: CE_BANK_BRANCHES_V iba_bnk_branch,
1885: IBY_EXT_BANK_ACCOUNTS_INT_V eba,
1886: CE_BANK_BRANCHES_V eba_bank_branch,
1887:
1888: /*

Line 1886: CE_BANK_BRANCHES_V eba_bank_branch,

1882: HZ_PARTIES payee,
1883: CE_BANK_ACCOUNTS iba,
1884: CE_BANK_BRANCHES_V iba_bnk_branch,
1885: IBY_EXT_BANK_ACCOUNTS_INT_V eba,
1886: CE_BANK_BRANCHES_V eba_bank_branch,
1887:
1888: /*
1889: * Fix for bug 5997016:
1890: *

Line 2615: CE_BANK_BRANCHES_V iba_bnk_branch,

2611: IBY_PP_FIRST_PARTY_V payer,
2612: HZ_PARTIES payee,
2613: HZ_LOCATIONS payee_loc,
2614: CE_BANK_ACCOUNTS iba,
2615: CE_BANK_BRANCHES_V iba_bnk_branch,
2616: IBY_EXT_BANK_ACCOUNTS_INT_V eba,
2617: CE_BANK_BRANCHES_V eba_bank_branch
2618: WHERE
2619: docs.document_payable_id = p_doc_id

Line 2617: CE_BANK_BRANCHES_V eba_bank_branch

2613: HZ_LOCATIONS payee_loc,
2614: CE_BANK_ACCOUNTS iba,
2615: CE_BANK_BRANCHES_V iba_bnk_branch,
2616: IBY_EXT_BANK_ACCOUNTS_INT_V eba,
2617: CE_BANK_BRANCHES_V eba_bank_branch
2618: WHERE
2619: docs.document_payable_id = p_doc_id
2620: AND docs.legal_entity_id = payer.party_legal_id
2621: AND docs.payee_party_id = payee.party_id

Line 2975: CE_BANK_BRANCHES_V iba_bnk_branch,

2971: /* Payer */
2972: IBY_PP_FIRST_PARTY_V payer,
2973: /* Payer bank */
2974: CE_BANK_ACCOUNTS iba,
2975: CE_BANK_BRANCHES_V iba_bnk_branch,
2976: /* Payee */
2977: HZ_PARTIES payee,
2978: HZ_LOCATIONS payee_loc,
2979: /* Payee bank */