DBA Data[Home] [Help]

APPS.JAI_ST_REVERSAL_EXTRACT_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 450: FROM AR_payment_schedules_all

446:
447: CURSOR c_total_ar_amount(cp_invoice_id NUMBER) IS
448: SELECT amount_due_original
449: ,amount_due_remaining
450: FROM AR_payment_schedules_all
451: WHERE customer_trx_id = cp_invoice_id;
452:
453: CURSOR c_total_ar_line_amount(cp_invoice_id NUMBER, cp_line_num NUMBER, cd_as_of_date DATE) IS
454: SELECT sum(rctg.acctd_amount)