DBA Data[Home] [Help]

APPS.JAI_ST_REVERSAL_EXTRACT_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 465: FROM AR_RECEIVABLE_APPLICATIONS_ALL

461: AND rctg.gl_date <= cd_as_of_date;
462:
463: CURSOR c_ar_applied_amount(cp_invoice_id NUMBER, cd_reversal_date DATE) IS
464: SELECT nvl(SUM(amount_applied),0)
465: FROM AR_RECEIVABLE_APPLICATIONS_ALL
466: WHERE applied_customer_trx_id = cp_invoice_id
467: AND apply_date<= cd_reversal_date;
468:
469: CURSOR c_ar_rc_st_amount(cp_invoice_id NUMBER, cp_line_num NUMBER, cd_reversal_date DATE) IS