APPS.LNS_BILLING_UTIL_PUB dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 969: ar_receivable_applications_all rec,

965: CURSOR get_data_crs(P_LOAN_ID NUMBER, P_DATE DATE) IS
966: select loan.funded_amount -
967: (select nvl(sum(rec.amount_applied), 0)
968: from
969: ar_receivable_applications_all rec,
970: LNS_AMORTIZATION_SCHEDS am
971: where
972: rec.application_type = 'CASH' and
973: trunc(rec.apply_date) <= trunc(P_DATE) and