DBA Data[Home] [Help]

APPS.AR_RECEIPT_LIB_PVT dependencies on IBY_EXT_BANK_ACCOUNTS_V

Line 1758: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE,

1754: p_customer_number IN hz_cust_accounts.account_number%TYPE,
1755: p_location IN hz_cust_site_uses.location%type,
1756: p_receipt_method_name IN OUT NOCOPY ar_receipt_methods.name%TYPE,
1757: /* 6612301 */
1758: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE,
1759: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
1760: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE,
1761: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE,
1762: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,

Line 1759: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE,

1755: p_location IN hz_cust_site_uses.location%type,
1756: p_receipt_method_name IN OUT NOCOPY ar_receipt_methods.name%TYPE,
1757: /* 6612301 */
1758: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE,
1759: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
1760: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE,
1761: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE,
1762: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1763: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,

Line 2017: iby_ext_bank_accounts_v bb

2013: bb.BANK_ACCOUNT_ID
2014: into p_customer_bank_branch_id
2015: ,p_customer_bank_account_id
2016: from iby_fndcpt_payer_assgn_instr_v a,
2017: iby_ext_bank_accounts_v bb
2018: where a.cust_account_id = p_customer_id
2019: and a.instrument_type = 'BANKACCOUNT'
2020: and ( a.acct_site_use_id = p_customer_site_use_id or a.acct_site_use_id is null)
2021: and a.currency_code = p_currency_code

Line 2050: iby_ext_bank_accounts_v bb

2046: bb.BANK_ACCOUNT_ID
2047: into p_customer_bank_branch_id,
2048: p_customer_bank_account_id
2049: from iby_fndcpt_payer_assgn_instr_v a,
2050: iby_ext_bank_accounts_v bb
2051: where a.cust_account_id = p_customer_id
2052: and a.instrument_type = 'BANKACCOUNT'
2053: and ( a.acct_site_use_id = p_customer_site_use_id or a.acct_site_use_id is null)
2054: and a.currency_code = p_currency_code

Line 2084: iby_ext_bank_accounts_v bb

2080: bb.BANK_ACCOUNT_ID
2081: into p_customer_bank_branch_id
2082: ,p_customer_bank_account_id
2083: from iby_fndcpt_payer_assgn_instr_v a,
2084: iby_ext_bank_accounts_v bb
2085: where a.cust_account_id = p_customer_id
2086: and a.instrument_type = 'BANKACCOUNT'
2087: and ( a.acct_site_use_id = p_customer_site_use_id or a.acct_site_use_id is null)
2088: and a.currency_code = p_currency_code