DBA Data[Home] [Help]

APPS.FV_APPLY_CASH_RECEIPT dependencies on FV_FINANCE_CHARGE_CONTROLS

Line 2419: --* : fv_finance_charge_controls SELECT *--

2415: --* : error *--
2416: --* : log_msg *--
2417: --* Tables Used : ra_customer_trx SELECT *--
2418: --* : ar_payment_schedules SELECT *--
2419: --* : fv_finance_charge_controls SELECT *--
2420: --* Logic : 1. Loop and Process the following steps for every Debit Memos that *--
2421: --* : exist for the invoice (That are due) *--
2422: --* : 2. If the debit memo was procesed earlier using the same cash *--
2423: --* : cash receipt, unapply the old application and apply once again *--

Line 2472: fv_finance_charge_controls fcc

2468: rct.trx_number invoice_number,
2469: rct.invoice_currency_code
2470: FROM ra_customer_trx rct,
2471: ar_payment_schedules aps,
2472: fv_finance_charge_controls fcc
2473: WHERE rct.related_customer_trx_id = c_invoice_id
2474: AND aps.customer_trx_id = rct.customer_trx_id
2475: AND rct.interface_header_attribute3 = fcc.charge_type
2476: AND aps.amount_due_remaining > 0