eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_RECEIPT_API_PUB dependencies on CE_BANK_ACCOUNTS

Line 174: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;

170: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
171: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
172: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
173: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
174: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
175: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
176: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
177: l_receipt_method_name ar_receipt_methods.name%TYPE;
178: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE;

Line 1040: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;

1036: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
1037: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
1038: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
1039: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
1040: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
1041: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
1042: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
1043: l_receipt_method_name ar_receipt_methods.name%TYPE;
1044: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE;

Line 3839: ce_bank_accounts cba,

3835: hz_cust_accounts hca,
3836: hz_parties party,
3837: /* Need to pass country code for SEPA specific receipts */
3838: ce_bank_acct_uses bau,
3839: ce_bank_accounts cba,
3840: hz_parties bank,
3841: hz_organization_profiles pr
3842: WHERE cr.cash_receipt_id = p_cash_receipt_id
3843: AND hca.cust_account_id = cr.pay_from_customer

Line 4798: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,

4794: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug4448307-4509459
4795: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
4796: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
4797: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
4798: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
4799: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
4800: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
4801: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
4802: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,

Line 4799: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,

4795: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
4796: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
4797: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
4798: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
4799: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
4800: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
4801: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
4802: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
4803: p_doc_sequence_value IN NUMBER DEFAULT NULL,