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_PREPAYMENTS_PUB dependencies on CE_BANK_ACCOUNTS

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

88: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
89: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
90: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
91: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type DEFAULT NULL,
92: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
93: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
94: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
95: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
96: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,

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

89: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
90: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
91: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type DEFAULT NULL,
92: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
93: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
94: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
95: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
96: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
97: p_doc_sequence_value IN NUMBER DEFAULT NULL,

Line 188: ce_bank_accounts cba,

184: hz_cust_accounts hca,
185: hz_parties party,
186: /* Need to pass country code for SEPA specific receipts */
187: ce_bank_acct_uses bau,
188: ce_bank_accounts cba,
189: hz_parties bank,
190: hz_organization_profiles pr
191: WHERE cr.cash_receipt_id = l_cash_receipt_id
192: AND hca.party_id = party.party_id