APPS.LNS_FINANCIALS dependencies on LNS_DISB_LINES

Line 5992: || LNS_DISB_HEADERS, LNS_DISB_LINES

5988: || Overview: procedure will run a loan projection ||
5989: || Parameter: loan_id
5990: ||
5991: || Source Tables: LNS_LOAN_HEADERS, LNS_TERMS, LNS_RATE_SCHEDULES,
5992: || LNS_DISB_HEADERS, LNS_DISB_LINES
5993: ||
5994: || Target Tables: None
5995: ||
5996: || Return value: x_amort_tbl is table of amortization records

Line 9353: || Source Tables: LNS_DISB_HEADERS, LNS_DISB_LINES

9349: || p_calc_method 'ACTUAL' or 'TARGET'
9350: ||
9351: || Return value: wtd average daily balance for the loan
9352: ||
9353: || Source Tables: LNS_DISB_HEADERS, LNS_DISB_LINES
9354: ||
9355: || Target Tables: NA
9356: ||
9357: || KNOWN ISSUES

Line 9384: from lns_disb_lines lines

9380:
9381: cursor c_actual_balance(p_loan_id number, p_from_date date, p_to_date date) IS
9382: select p_from_date - 1
9383: ,nvl(sum(line_amount), 0)
9384: from lns_disb_lines lines
9385: where disb_header_id in (select disb_header_id from lns_disb_headers where loan_id = p_loan_id)
9386: and trunc(disbursement_date) < p_from_date
9387: UNION
9388: select trunc(inv.creation_date)

Line 9392: ,lns_disb_lines line

9388: select trunc(inv.creation_date)
9389: ,nvl(sum(amount), 0)
9390: from AP_INVOICE_PAYMENTS_ALL inv
9391: ,lns_disb_headers head
9392: ,lns_disb_lines line
9393: where head.loan_id = p_loan_id
9394: and line.disb_header_id = head.disb_header_id
9395: and line.invoice_id is not null
9396: and line.invoice_id = inv.invoice_id

Line 9404: from lns_disb_lines

9400: group by trunc(inv.creation_date);
9401: /* raverma 12-13-05 removed
9402: select disbursement_date
9403: ,sum(line_amount)
9404: from lns_disb_lines
9405: where disb_header_id in (select disb_header_id from lns_disb_headers where loan_id = p_loan_id)
9406: and disbursement_date is not null
9407: and trunc(disbursement_date) >= p_from_date
9408: and trunc(disbursement_date) < p_to_date