DBA Data[Home] [Help]

APPS.AR_RECEIPT_API_PUB dependencies on CE_BANK_ACCOUNTS

Line 47: -- to ce_bank_accounts table if the column selected does not appear in

43: -- where possible.
44: --
45: -- 2. Reference to ap_bank_accounts for internal bank accounts has been
46: -- changed to ce_bank_acct_uses. An additional join may have been added
47: -- to ce_bank_accounts table if the column selected does not appear in
48: -- the uses table.
49: --
50: -- 3. All bank branch/bank account related identifiers declared with %TYPE
51: -- has been appropriately changed to point to the new data model.

Line 209: remittance_bank_account_num ce_bank_accounts.bank_account_name%TYPE,

205: customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE,
206: customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE,
207: customer_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE,
208: remit_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE,
209: remittance_bank_account_num ce_bank_accounts.bank_account_name%TYPE,
210: remittance_bank_account_name ce_bank_accounts.bank_account_num%TYPE,
211: receipt_method_id ar_receipt_methods.receipt_method_id%TYPE,
212: receipt_method_name ar_receipt_methods.name%TYPE
213: );

Line 210: remittance_bank_account_name ce_bank_accounts.bank_account_num%TYPE,

206: customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE,
207: customer_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE,
208: remit_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE,
209: remittance_bank_account_num ce_bank_accounts.bank_account_name%TYPE,
210: remittance_bank_account_name ce_bank_accounts.bank_account_num%TYPE,
211: receipt_method_id ar_receipt_methods.receipt_method_id%TYPE,
212: receipt_method_name ar_receipt_methods.name%TYPE
213: );
214: TYPE G_unapp_rec_type IS RECORD

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

518: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --The default site use bug4448307-4509459.
519: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
520: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
521: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
522: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
523: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
524: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
525: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
526: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,

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

519: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
520: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
521: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
522: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
523: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
524: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
525: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
526: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
527: p_doc_sequence_value IN NUMBER DEFAULT NULL,