DBA Data[Home] [Help]

APPS.IBY_PAYGROUP_PUB dependencies on CE_BANK_ACCOUNTS

Line 1030: CE_BANK_ACCOUNTS iba

1026: IBY_PAYMENT_PROFILES ppf,
1027: IBY_PAY_SERVICE_REQUESTS prq,
1028: IBY_EXTERNAL_PAYEES_ALL ext_payee,
1029: IBY_PAYMENT_METHODS_B pmt_mthd,
1030: CE_BANK_ACCOUNTS iba
1031: WHERE prq.payment_service_request_id = p_payment_request_id
1032: AND docs.payment_service_request_id = prq.payment_service_request_id
1033: AND docs.payment_profile_id = ppf.payment_profile_id
1034: AND ppf.system_profile_code = pcr.system_profile_code(+)

Line 1082: CE_BANK_ACCOUNTS iba

1078: SELECT
1079: iba.bank_account_id int_bank_account,
1080: iba.account_owner_org_id legal_entity_id
1081: FROM
1082: CE_BANK_ACCOUNTS iba
1083: ;
1084: */
1085:
1086: BEGIN

Line 4635: CE_BANK_ACCOUNTS

4631: INTO
4632: l_ce_min_pmt_ctrl,
4633: l_ce_max_pmt_ctrl
4634: FROM
4635: CE_BANK_ACCOUNTS
4636: WHERE
4637: bank_account_id = x_paymentTab(i).internal_bank_account_id
4638: ;
4639:

Line 8104: CE_BANK_ACCOUNTS iba,

8100: IBY_SYS_PMT_PROFILES_B sys_prof,
8101: IBY_ACCT_PMT_PROFILES_B acct_prof,
8102: IBY_TRANSMIT_CONFIGS_B txconf,
8103: IBY_TRANSMIT_PROTOCOLS_B txproto,
8104: CE_BANK_ACCOUNTS iba,
8105: CE_BANK_BRANCHES_V iba_branch
8106: WHERE
8107: pmts.payment_id = p_payment_id
8108: AND pmts.internal_bank_account_id = iba.bank_account_id

Line 11858: CE_BANK_ACCOUNTS iba,

11854: XLE_FIRSTPARTY_INFORMATION_V payer,
11855: HZ_PARTIES payer_party,
11856:
11857: /* Payer bank */
11858: CE_BANK_ACCOUNTS iba,
11859: CE_BANK_BRANCHES_V iba_bnk_branch,
11860: HZ_PARTY_SITES iba_branch_party_site,
11861:
11862: /* Payee */

Line 13001: CE_BANK_ACCOUNTS iba,

12997: XLE_FIRSTPARTY_INFORMATION_V payer,
12998: HZ_PARTIES payer_party,
12999:
13000: /* Payer bank */
13001: CE_BANK_ACCOUNTS iba,
13002: CE_BANK_BRANCHES_V iba_bnk_branch,
13003: HZ_PARTY_SITES iba_branch_party_site,
13004:
13005: /* Payee */