APPS.LNS_FINANCIALS dependencies on LNS_REC_ACT_CASH_CM_V

Line 7781: from LNS_REC_ACT_CASH_CM_V

7777: -- this cursor is to get the last activity date on the loan
7778: -- payoff processing will use this date
7779: cursor c_last_loan_activity(p_loan_id number) is
7780: select max(activity_date)
7781: from LNS_REC_ACT_CASH_CM_V
7782: where activity_code = 'PMT'
7783: and loan_id = p_loan_id;
7784:
7785: -- begin fix for bug 6724561

Line 10799: from LNS_REC_ACT_CASH_CM_V rav

10795: union all
10796: select trunc(activity_date) activity_date,
10797: sum(activity_amount) activity_amount,
10798: LNS_BILLING_UTIL_PUB.LOAN_BALANCE_BY_DATE(P_LOAN_ID, activity_date) --min(balance_by_activity_date) ending_balance
10799: from LNS_REC_ACT_CASH_CM_V rav
10800: where rav.loan_id = p_loan_id and
10801: line_type_code = 'PRIN' and
10802: (activity_code in ('PMT', 'ADJ') or (activity_code = 'CM' and activity_number like 'NET%'))
10803: group by activity_date