APPS.IBY_PAYGROUP_PUB dependencies on CE_BANK_ACCOUNTS

Line 1703: CE_BANK_ACCOUNTS iba

1699: IBY_PAYMENT_PROFILES ppf,
1700: IBY_PAY_SERVICE_REQUESTS prq,
1701: IBY_EXTERNAL_PAYEES_ALL ext_payee,
1702: IBY_PAYMENT_METHODS_B pmt_mthd,
1703: CE_BANK_ACCOUNTS iba
1704: WHERE prq.payment_service_request_id = p_payment_request_id
1705: AND docs.payment_service_request_id = prq.payment_service_request_id
1706: AND docs.payment_profile_id = ppf.payment_profile_id
1707: AND ppf.system_profile_code = pcr.system_profile_code(+)

Line 1756: CE_BANK_ACCOUNTS iba

1752: SELECT
1753: iba.bank_account_id int_bank_account,
1754: iba.account_owner_org_id legal_entity_id
1755: FROM
1756: CE_BANK_ACCOUNTS iba
1757: ;
1758: */
1759:
1760: BEGIN

Line 3783: CE_BANK_ACCOUNTS iba

3779: IBY_PAYMENT_PROFILES ppf,
3780: IBY_PAY_SERVICE_REQUESTS prq,
3781: IBY_EXTERNAL_PAYEES_ALL ext_payee,
3782: IBY_PAYMENT_METHODS_B pmt_mthd,
3783: CE_BANK_ACCOUNTS iba
3784: WHERE prq.payment_service_request_id = p_payment_request_id
3785: AND docs.payment_service_request_id = prq.payment_service_request_id
3786: AND docs.payment_profile_id = ppf.payment_profile_id
3787: AND ppf.system_profile_code = pcr.system_profile_code(+)

Line 3836: CE_BANK_ACCOUNTS iba

3832: SELECT
3833: iba.bank_account_id int_bank_account,
3834: iba.account_owner_org_id legal_entity_id
3835: FROM
3836: CE_BANK_ACCOUNTS iba
3837: ;
3838: */
3839:
3840: l_length number(15):=0;

Line 10737: CE_BANK_ACCOUNTS

10733: l_ce_currency_code,
10734: l_ce_min_pmt_ctrl,
10735: l_ce_max_pmt_ctrl
10736: FROM
10737: CE_BANK_ACCOUNTS
10738: WHERE
10739: bank_account_id = IBY_PAYGROUP_PUB.pmtTable.internal_bank_account_id(p_trx_pmt_line_index)
10740: ;
10741:

Line 18103: l_int_bank_acct_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;

18099:
18100:
18101:
18102: int_bnk_index VARCHAR2(2000);
18103: l_int_bank_acct_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
18104: l_country CE_BANK_BRANCHES_V.country%TYPE;
18105: l_bank_home_country CE_BANK_BRANCHES_V.bank_home_country%TYPE;
18106: l_allow_zero_pmt_flag CE_BANK_ACCOUNTS.zero_amount_allowed%TYPE;
18107:

Line 18106: l_allow_zero_pmt_flag CE_BANK_ACCOUNTS.zero_amount_allowed%TYPE;

18102: int_bnk_index VARCHAR2(2000);
18103: l_int_bank_acct_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
18104: l_country CE_BANK_BRANCHES_V.country%TYPE;
18105: l_bank_home_country CE_BANK_BRANCHES_V.bank_home_country%TYPE;
18106: l_allow_zero_pmt_flag CE_BANK_ACCOUNTS.zero_amount_allowed%TYPE;
18107:
18108: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE;
18109: l_payment_format_cd IBY_PAYMENT_PROFILES.payment_format_code%TYPE;
18110: l_bepid IBY_PAYMENT_PROFILES.bepid%TYPE;

Line 18240: FROM CE_BANK_ACCOUNTS cba, CE_BANK_BRANCHES_V cb

18236: INTO l_int_bank_acct_id,
18237: l_country,
18238: l_bank_home_country,
18239: l_allow_zero_pmt_flag
18240: FROM CE_BANK_ACCOUNTS cba, CE_BANK_BRANCHES_V cb
18241: WHERE cba.bank_branch_id = cb.branch_party_id
18242: AND cba.bank_account_id = IBY_PAYGROUP_PUB.pmtTable.INTERNAL_BANK_ACCOUNT_ID(l_trx_valid_index);
18243:
18244:

Line 24039: CE_BANK_ACCOUNTS iba,

24035:
24036: FROM
24037:
24038: /* Payer bank */
24039: CE_BANK_ACCOUNTS iba,
24040: CE_BANK_BRANCHES_V iba_bnk_branch,
24041: HZ_PARTY_SITES iba_branch_party_site,
24042: /* RFC */
24043: HZ_CODE_ASSIGNMENTS rfc_ca