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.

APPS.LNS_FINANCIALS dependencies on LNS_DISB_HEADERS

Line 606: 'DIRECT', (select count(1) from lns_disb_headers where loan_id = p_loan_id and status is null and PAYMENT_REQUEST_DATE is not null),

602: l_CUSTOM_SET_REC LNS_CUSTOM_PUB.custom_settings_type;
603:
604: cursor c_fund_sched_exist(p_loan_id number) is
605: select decode(loan.loan_class_code,
606: 'DIRECT', (select count(1) from lns_disb_headers where loan_id = p_loan_id and status is null and PAYMENT_REQUEST_DATE is not null),
607: 'ERS', (select count(1) from lns_loan_lines where loan_id = p_loan_id and (status is null or status = 'PENDING') and end_date is null))
608: from lns_loan_headers_all loan
609: where loan.loan_id = p_loan_id;
610:

Line 2510: 'DIRECT', (select count(1) from lns_disb_headers where loan_id = p_loan_id and status is null and PAYMENT_REQUEST_DATE is not null),

2506: and nvl(PHASE, 'TERM') = 'TERM';
2507:
2508: cursor c_fund_sched_exist(p_loan_id number) is
2509: select decode(loan.loan_class_code,
2510: 'DIRECT', (select count(1) from lns_disb_headers where loan_id = p_loan_id and status is null and PAYMENT_REQUEST_DATE is not null),
2511: 'ERS', (select count(1) from lns_loan_lines where loan_id = p_loan_id and (status is null or status = 'PENDING') and end_date is null))
2512: from lns_loan_headers_all loan
2513: where loan.loan_id = p_loan_id;
2514:

Line 3901: 'DIRECT', (select count(1) from lns_disb_headers where loan_id = p_loan_id and status is null and PAYMENT_REQUEST_DATE is not null),

3897: order by PAYMENT_NUMBER desc;
3898:
3899: cursor c_fund_sched_exist(p_loan_id number) is
3900: select decode(loan.loan_class_code,
3901: 'DIRECT', (select count(1) from lns_disb_headers where loan_id = p_loan_id and status is null and PAYMENT_REQUEST_DATE is not null),
3902: 'ERS', (select count(1) from lns_loan_lines where loan_id = p_loan_id and (status is null or status = 'PENDING') and end_date is null))
3903: from lns_loan_headers_all loan
3904: where loan.loan_id = p_loan_id;
3905:

Line 5137: 'DIRECT', (select count(1) from lns_disb_headers where loan_id = p_loan_id and status is null and PAYMENT_REQUEST_DATE is not null),

5133: and nvl(PHASE, 'TERM') = 'TERM';
5134:
5135: cursor c_fund_sched_exist(p_loan_id number) is
5136: select decode(loan.loan_class_code,
5137: 'DIRECT', (select count(1) from lns_disb_headers where loan_id = p_loan_id and status is null and PAYMENT_REQUEST_DATE is not null),
5138: 'ERS', (select count(1) from lns_loan_lines where loan_id = p_loan_id and (status is null or status = 'PENDING') and end_date is null))
5139: from lns_loan_headers_all loan
5140: where loan.loan_id = p_loan_id;
5141:

Line 6438: from lns_disb_headers

6434: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
6435:
6436: cursor c_total_disbursed(p_loan_id number, p_from_date date, p_to_date date) is
6437: select nvl(sum(header_amount), 0)
6438: from lns_disb_headers
6439: where loan_id = p_loan_id
6440: and trunc(payment_request_date) >= p_from_date
6441: and trunc(payment_request_date) < p_to_date;
6442:

Line 6898: || LNS_DISB_HEADERS, LNS_DISB_LINES

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

Line 6951: from lns_disb_headers

6947: l_invalid_disb number;
6948:
6949: cursor c_disbursements(p_loan_id number) is
6950: select nvl(sum(header_amount), 0)
6951: from lns_disb_headers
6952: where loan_id = p_loan_id;
6953:
6954: BEGIN
6955: -- Standard Start of API savepoint

Line 8105: || Source Tables: LNS_LOAN_HEADERS_ALL, LNS_DISB_HEADERS

8101: || -- the term will change to X MONTHS if TERM was > MONTHS
8102: ||
8103: || Parameter: p_loan_id = loan_id
8104: ||
8105: || Source Tables: LNS_LOAN_HEADERS_ALL, LNS_DISB_HEADERS
8106: || LNS_TERMS
8107: ||
8108: || Target Tables: LNS_LOAN_HEADERS_ALL, LNS_TERMS
8109: ||

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

8153: CURSOR move_maturity_date_cur(P_LOAN_ID number) IS
8154: select
8155: CASE
8156: WHEN (nvl(loan.CURRENT_PHASE, 'TERM') = 'OPEN') THEN
8157: sign(trunc(loan.OPEN_MATURITY_DATE) - (select trunc(max(PAYMENT_REQUEST_DATE)) from LNS_DISB_HEADERS where LOAN_ID = loan.LOAN_ID))
8158: WHEN (nvl(loan.CURRENT_PHASE, 'TERM') = 'TERM' and loan.MULTIPLE_FUNDING_FLAG = 'N') THEN
8159: sign(trunc(loan.LOAN_MATURITY_DATE) - (select trunc(max(PAYMENT_REQUEST_DATE)) from LNS_DISB_HEADERS where LOAN_ID = loan.LOAN_ID))
8160: ELSE
8161: 1

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

8155: CASE
8156: WHEN (nvl(loan.CURRENT_PHASE, 'TERM') = 'OPEN') THEN
8157: sign(trunc(loan.OPEN_MATURITY_DATE) - (select trunc(max(PAYMENT_REQUEST_DATE)) from LNS_DISB_HEADERS where LOAN_ID = loan.LOAN_ID))
8158: WHEN (nvl(loan.CURRENT_PHASE, 'TERM') = 'TERM' and loan.MULTIPLE_FUNDING_FLAG = 'N') THEN
8159: sign(trunc(loan.LOAN_MATURITY_DATE) - (select trunc(max(PAYMENT_REQUEST_DATE)) from LNS_DISB_HEADERS where LOAN_ID = loan.LOAN_ID))
8160: ELSE
8161: 1
8162: END
8163: from lns_loan_headers loan

Line 8185: from lns_disb_headers

8181: and h.loan_id = t.loan_id;
8182:
8183: cursor c_max_pay_req_date(p_loan_id number) is
8184: select max(payment_request_date)
8185: from lns_disb_headers
8186: where loan_id = p_loan_id;
8187:
8188: begin
8189: -- Standard Start of API savepoint

Line 10284: 'DIRECT', (select nvl(sum(disb_line.LINE_AMOUNT), 0) from lns_disb_lines disb_line, lns_disb_headers disb_hdr

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

Line 10297: 'DIRECT', (select nvl(sum(disb_hdr.HEADER_AMOUNT), 0) from lns_disb_headers disb_hdr

10293:
10294: cursor c_get_loan_balance1(p_loan_id number, p_date date) is
10295: select
10296: decode(loan.loan_class_code,
10297: 'DIRECT', (select nvl(sum(disb_hdr.HEADER_AMOUNT), 0) from lns_disb_headers disb_hdr
10298: where disb_hdr.loan_id = loan.loan_id and
10299: disb_hdr.STATUS is null and
10300: (disb_hdr.PAYMENT_REQUEST_DATE is null or trunc(disb_hdr.PAYMENT_REQUEST_DATE) <= trunc(p_date))),
10301: 'ERS', (select nvl(sum(lines.REQUESTED_AMOUNT), 0) from lns_loan_lines lines

Line 10525: || Source Tables: LNS_DISB_HEADERS, LNS_DISB_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

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

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)

Line 10571: ,lns_disb_headers head

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

Line 10588: from lns_disb_headers

10584: select * from
10585: (select p_from_date activity_date
10586: ,nvl(sum(header_amount),0)
10587: ,1 display_order
10588: from lns_disb_headers
10589: where loan_id = p_loan_id
10590: and trunc(payment_request_date) <= p_from_date
10591: UNION
10592: select payment_request_date activity_date

Line 10595: from lns_disb_headers

10591: UNION
10592: select payment_request_date activity_date
10593: ,nvl(sum(header_amount),0)
10594: ,2 display_order
10595: from lns_disb_headers
10596: where loan_id = p_loan_id
10597: and trunc(payment_request_date) > p_from_date
10598: and trunc(payment_request_date) < p_to_date
10599: group by payment_request_date