[Home] [Help]
6894: || Overview: procedure will run a loan projection ||
6895: || Parameter: loan_id
6896: ||
6897: || Source Tables: LNS_LOAN_HEADERS, LNS_TERMS, LNS_RATE_SCHEDULES,
6898: || LNS_DISB_HEADERS, LNS_DISB_LINES
6899: ||
6900: || Target Tables: None
6901: ||
6902: || Return value: x_amort_tbl is table of amortization records
10280:
10281: cursor c_get_loan_balance(p_loan_id number, p_date date) is
10282: select
10283: decode(loan.loan_class_code,
10284: 'DIRECT', (select nvl(sum(disb_line.LINE_AMOUNT), 0) from lns_disb_lines disb_line, lns_disb_headers disb_hdr
10285: where disb_hdr.loan_id = loan.loan_id and /*disb_hdr.phase = 'TERM' and */
10286: disb_hdr.disb_header_id = disb_line.disb_header_id and disb_line.STATUS = 'FULLY_FUNDED' and
10287: trunc(disb_line.DISBURSEMENT_DATE) <= trunc(p_date)),
10288: 'ERS', (select nvl(sum(lines.REQUESTED_AMOUNT), 0) from lns_loan_lines lines
10521: || p_calc_method 'ACTUAL' or 'TARGET'
10522: ||
10523: || Return value: wtd average daily balance for the loan
10524: ||
10525: || Source Tables: LNS_DISB_HEADERS, LNS_DISB_LINES
10526: ||
10527: || Target Tables: NA
10528: ||
10529: || KNOWN ISSUES
10559: select * from
10560: (select p_from_date activity_date
10561: ,nvl(sum(line_amount), 0)
10562: ,1 display_order
10563: from lns_disb_lines lines
10564: where disb_header_id in (select disb_header_id from lns_disb_headers where loan_id = p_loan_id)
10565: and trunc(disbursement_date) <= p_from_date
10566: UNION
10567: select trunc(line.disbursement_date) activity_date
10568: ,nvl(sum(inv.amount), 0)
10569: ,2 display_order
10570: from AP_INVOICE_PAYMENTS_ALL inv
10571: ,lns_disb_headers head
10572: ,lns_disb_lines line
10573: where head.loan_id = p_loan_id
10574: and line.disb_header_id = head.disb_header_id
10575: and line.invoice_id is not null
10576: and line.invoice_id = inv.invoice_id