APPS.LNS_BILLING_UTIL_PUB dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 741: ar_receivable_applications_all rec,

737: CURSOR get_data_crs(P_LOAN_ID NUMBER, P_DATE DATE) IS
738: select loan.funded_amount -
739: (select nvl(sum(rec.amount_applied), 0)
740: from
741: ar_receivable_applications_all rec,
742: LNS_AMORTIZATION_SCHEDS am
743: where
744: rec.application_type = 'CASH' and
745: trunc(rec.apply_date) <= trunc(P_DATE) and