DBA Data[Home] [Help]

APPS.AR_RECEIPT_LIB_PVT dependencies on IBY_EXT_BANK_ACCOUNTS_V

Line 1765: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE,

1761: p_customer_number IN hz_cust_accounts.account_number%TYPE,
1762: p_location IN hz_cust_site_uses.location%type,
1763: p_receipt_method_name IN OUT NOCOPY ar_receipt_methods.name%TYPE,
1764: /* 6612301 */
1765: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE,
1766: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
1767: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE,
1768: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE,
1769: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,

Line 1766: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE,

1762: p_location IN hz_cust_site_uses.location%type,
1763: p_receipt_method_name IN OUT NOCOPY ar_receipt_methods.name%TYPE,
1764: /* 6612301 */
1765: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE,
1766: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE,
1767: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE,
1768: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE,
1769: p_currency_code IN OUT NOCOPY ar_cash_receipts.currency_code%TYPE,
1770: p_exchange_rate_type IN OUT NOCOPY ar_cash_receipts.exchange_rate_type%TYPE,

Line 2024: iby_ext_bank_accounts_v bb

2020: bb.BANK_ACCOUNT_ID
2021: into p_customer_bank_branch_id
2022: ,p_customer_bank_account_id
2023: from iby_fndcpt_payer_assgn_instr_v a,
2024: iby_ext_bank_accounts_v bb
2025: where a.cust_account_id = p_customer_id
2026: and a.instrument_type = 'BANKACCOUNT'
2027: and ( a.acct_site_use_id = p_customer_site_use_id or a.acct_site_use_id is null)
2028: and a.currency_code = p_currency_code

Line 2057: iby_ext_bank_accounts_v bb

2053: bb.BANK_ACCOUNT_ID
2054: into p_customer_bank_branch_id,
2055: p_customer_bank_account_id
2056: from iby_fndcpt_payer_assgn_instr_v a,
2057: iby_ext_bank_accounts_v bb
2058: where a.cust_account_id = p_customer_id
2059: and a.instrument_type = 'BANKACCOUNT'
2060: and ( a.acct_site_use_id = p_customer_site_use_id or a.acct_site_use_id is null)
2061: and a.currency_code = p_currency_code

Line 2091: iby_ext_bank_accounts_v bb

2087: bb.BANK_ACCOUNT_ID
2088: into p_customer_bank_branch_id
2089: ,p_customer_bank_account_id
2090: from iby_fndcpt_payer_assgn_instr_v a,
2091: iby_ext_bank_accounts_v bb
2092: where a.cust_account_id = p_customer_id
2093: and a.instrument_type = 'BANKACCOUNT'
2094: and ( a.acct_site_use_id = p_customer_site_use_id or a.acct_site_use_id is null)
2095: and a.currency_code = p_currency_code