eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.LNS_FINANCIALS dependencies on LNS_DISB_HEADERS

Line 5745: from lns_disb_headers

5741:
5742: cursor c_total_disbursed(p_loan_id number, p_from_date date, p_to_date date)
5743: is
5744: select nvl(sum(header_amount), 0)
5745: from lns_disb_headers
5746: where loan_id = p_loan_id
5747: and trunc(payment_request_date) >= p_from_date
5748: and trunc(payment_request_date) < p_to_date;
5749:

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 6069: from lns_disb_headers

6065: and fee_installment = p_installment;
6066:
6067: cursor c_disbursements(p_loan_id number) is
6068: select nvl(sum(header_amount), 0)
6069: from lns_disb_headers
6070: where loan_id = p_loan_id;
6071:
6072: -- if there is a return count then some dates are invalid
6073: cursor c_invalid_disb(p_loan_id number) is

Line 6075: from lns_disb_headers dh

6071:
6072: -- if there is a return count then some dates are invalid
6073: cursor c_invalid_disb(p_loan_id number) is
6074: select count(1)
6075: from lns_disb_headers dh
6076: ,lns_loan_headers h
6077: where h.loan_id = dh.loan_id
6078: and trunc(dh.payment_request_date) < trunc(h.open_loan_start_date)
6079: and h.loan_id = p_loan_id;

Line 7324: || Source Tables: LNS_LOAN_HEADERS_ALL, LNS_DISB_HEADERS

7320: || -- the term will change to X MONTHS if TERM was > MONTHS
7321: ||
7322: || Parameter: p_loan_id = loan_id
7323: ||
7324: || Source Tables: LNS_LOAN_HEADERS_ALL, LNS_DISB_HEADERS
7325: || LNS_TERMS
7326: ||
7327: || Target Tables: LNS_LOAN_HEADERS_ALL, LNS_TERMS
7328: ||

Line 7376: sign(trunc(loan.OPEN_MATURITY_DATE) - (select trunc(max(PAYMENT_REQUEST_DATE)) from LNS_DISB_HEADERS where LOAN_ID = loan.LOAN_ID))

7372: CURSOR move_maturity_date_cur(P_LOAN_ID number) IS
7373: select
7374: CASE
7375: WHEN (nvl(loan.CURRENT_PHASE, 'TERM') = 'OPEN') THEN
7376: sign(trunc(loan.OPEN_MATURITY_DATE) - (select trunc(max(PAYMENT_REQUEST_DATE)) from LNS_DISB_HEADERS where LOAN_ID = loan.LOAN_ID))
7377: WHEN (nvl(loan.CURRENT_PHASE, 'TERM') = 'TERM' and loan.MULTIPLE_FUNDING_FLAG = 'N') THEN
7378: sign(trunc(loan.LOAN_MATURITY_DATE) - (select trunc(max(PAYMENT_REQUEST_DATE)) from LNS_DISB_HEADERS where LOAN_ID = loan.LOAN_ID))
7379: ELSE
7380: 1

Line 7378: sign(trunc(loan.LOAN_MATURITY_DATE) - (select trunc(max(PAYMENT_REQUEST_DATE)) from LNS_DISB_HEADERS where LOAN_ID = loan.LOAN_ID))

7374: CASE
7375: WHEN (nvl(loan.CURRENT_PHASE, 'TERM') = 'OPEN') THEN
7376: sign(trunc(loan.OPEN_MATURITY_DATE) - (select trunc(max(PAYMENT_REQUEST_DATE)) from LNS_DISB_HEADERS where LOAN_ID = loan.LOAN_ID))
7377: WHEN (nvl(loan.CURRENT_PHASE, 'TERM') = 'TERM' and loan.MULTIPLE_FUNDING_FLAG = 'N') THEN
7378: sign(trunc(loan.LOAN_MATURITY_DATE) - (select trunc(max(PAYMENT_REQUEST_DATE)) from LNS_DISB_HEADERS where LOAN_ID = loan.LOAN_ID))
7379: ELSE
7380: 1
7381: END
7382: from lns_loan_headers loan

Line 7404: from lns_disb_headers

7400: and h.loan_id = t.loan_id;
7401:
7402: cursor c_max_pay_req_date(p_loan_id number) is
7403: select max(payment_request_date)
7404: from lns_disb_headers
7405: where loan_id = p_loan_id;
7406:
7407: begin
7408: -- Standard Start of API savepoint

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 9385: where disb_header_id in (select disb_header_id from lns_disb_headers where loan_id = p_loan_id)

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)
9389: ,nvl(sum(amount), 0)

Line 9391: ,lns_disb_headers head

9387: UNION
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

Line 9405: where disb_header_id in (select disb_header_id from lns_disb_headers where loan_id = p_loan_id)

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
9409: group by disbursement_date;

Line 9414: from lns_disb_headers

9410: */
9411: cursor c_theoretical_balance(p_loan_id number, p_from_date date, p_to_date date) IS
9412: select p_from_date - 1
9413: ,nvl(sum(header_amount),0)
9414: from lns_disb_headers
9415: where loan_id = p_loan_id
9416: and trunc(payment_request_date) < p_from_date
9417: UNION
9418: select payment_request_date

Line 9420: from lns_disb_headers

9416: and trunc(payment_request_date) < p_from_date
9417: UNION
9418: select payment_request_date
9419: ,nvl(sum(header_amount),0)
9420: from lns_disb_headers
9421: where loan_id = p_loan_id
9422: and trunc(payment_request_date) >= p_from_date
9423: and trunc(payment_request_date) < p_to_date
9424: group by payment_request_date;