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_LOAN_HEADERS_ALL

Line 569: FROM lns_loan_headers_all h

565: l_customized varchar2(1);
566:
567: cursor c_customized (p_loan_id number) is
568: SELECT nvl(h.custom_payments_flag, 'N')
569: FROM lns_loan_headers_all h
570: WHERE loan_id = p_loan_id;
571:
572: cursor c_customSchedule(p_loan_id number) is
573: select payment_number installment_number

Line 684: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');

680: ,x_msg_data => l_msg_data
681: ,x_return_status => l_return_status
682: ,p_col_id => p_loan_id
683: ,p_col_name => 'LOAN_ID'
684: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
685:
686: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
687: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
688: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');

Line 1185: FROM lns_loan_headers_all h

1181:
1182: -- this is for get custom dates
1183: cursor c_customized (p_loan_id number) is
1184: SELECT nvl(h.custom_payments_flag, 'N')
1185: FROM lns_loan_headers_all h
1186: WHERE loan_id = p_loan_id;
1187:
1188: cursor c_customSchedule(p_loan_id number, p_installment number) is
1189: select payment_number installment_number

Line 6109: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');

6105: ,x_msg_data => l_msg_data
6106: ,x_return_status => l_return_status
6107: ,p_col_id => p_loan_id
6108: ,p_col_name => 'LOAN_ID'
6109: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
6110:
6111: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6112: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
6113: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');

Line 6295: from lns_loan_headers_all h,

6291: ,begin_installment_number
6292: ,end_installment_number
6293: ,nvl(interest_only_flag, 'N')
6294: ,nvl(floating_flag, 'N')
6295: from lns_loan_headers_all h,
6296: lns_terms t,
6297: lns_rate_schedules rs
6298: where h.loan_id = p_loan_id
6299: and h.loan_id = t.loan_id

Line 6847: FROM lns_loan_headers_all h

6843: ,nvl(t.prin_payment_frequency, t.loan_payment_frequency)
6844: ,decode(trunc(nvl(t.prin_first_pay_date, t.first_payment_date)) - trunc(h.loan_start_date), 0, 'N', 'Y') -- calculate in advance or arrears for principal
6845: ,nvl(t.PENAL_INT_RATE, 0)
6846: ,nvl(t.PENAL_INT_GRACE_DAYS, 0)
6847: FROM lns_loan_headers_all h
6848: ,lns_terms t
6849: ,fnd_currencies curr
6850: WHERE h.loan_id = p_loan_id
6851: AND t.loan_id = h.loan_id

Line 6880: FROM lns_loan_headers_all lnh,

6876: CURSOR c_reamortization(p_Loan_id NUMBER) IS
6877: SELECT nvl(reamortization_amount, 0)
6878: ,nvl(reamortize_from_installment, 0)
6879: ,nvl(reamortize_to_installment, 0)
6880: FROM lns_loan_headers_all lnh,
6881: lns_amortization_scheds amort1
6882: WHERE lnh.loan_id = amort1.loan_id(+)
6883: AND lnh.loan_id = p_loan_id
6884: AND amort1.reamortization_amount > 0;

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 7327: || Target Tables: LNS_LOAN_HEADERS_ALL, LNS_TERMS

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: ||
7329: || Return value: Standard Oracle API
7330: ||
7331: || MODIFICATION HISTORY

Line 7670: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');

7666: ,x_msg_data => l_msg_data
7667: ,x_return_status => l_return_status
7668: ,p_col_id => p_loan_id
7669: ,p_col_name => 'LOAN_ID'
7670: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
7671:
7672: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
7673: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
7674: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');

Line 8895: lns_loan_headers_all h

8891:
8892: select rs.current_interest_rate into l_rate
8893: from lns_rate_schedules rs,
8894: lns_terms t,
8895: lns_loan_headers_all h
8896: where h.loan_id = p_loan_id
8897: and h.loan_id = t.loan_id
8898: and rs.term_id = t.term_id
8899: and rs.start_date_active <= sysdate

Line 9127: ' From lns_loan_headers_all ' ||

9123: -- logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
9124:
9125: Execute Immediate
9126: ' Select Loan_Status ' ||
9127: ' From lns_loan_headers_all ' ||
9128: ' where loan_id = :p_loan_id'
9129: into l_loan_status
9130: using p_loan_id;
9131:

Line 9134: l_table := 'LNS_LOAN_HEADERS_ALL';

9130: using p_loan_id;
9131:
9132: if l_loan_status = 'APPROVED' then
9133: l_column := 'REQUESTED_AMOUNT';
9134: l_table := 'LNS_LOAN_HEADERS_ALL';
9135:
9136: elsif l_loan_Status = 'ACTIVE' then
9137: l_column := 'TOTAL_PRINCIPAL_BALANCE';
9138: l_table := 'LNS_PAY_SUM_V';

Line 9152: -- l_table := 'LNS_LOAN_HEADERS_ALL';

9148: elsif l_loan_Status = 'PAIDOFF' then
9149: l_column := 'TOTAL_PRINCIPAL_BALANCE';
9150: l_table := 'LNS_PAY_SUM_V';
9151: -- l_column := 'REQUESTED_AMOUNT';
9152: -- l_table := 'LNS_LOAN_HEADERS_ALL';
9153:
9154: elsif l_loan_status = 'PENDING' then
9155: l_column := 'REQUESTED_AMOUNT';
9156: l_table := 'LNS_LOAN_HEADERS_ALL';

Line 9156: l_table := 'LNS_LOAN_HEADERS_ALL';

9152: -- l_table := 'LNS_LOAN_HEADERS_ALL';
9153:
9154: elsif l_loan_status = 'PENDING' then
9155: l_column := 'REQUESTED_AMOUNT';
9156: l_table := 'LNS_LOAN_HEADERS_ALL';
9157:
9158: elsif l_loan_status = 'INCOMPLETE' then
9159: l_column := 'REQUESTED_AMOUNT';
9160: l_table := 'LNS_LOAN_HEADERS_ALL';

Line 9160: l_table := 'LNS_LOAN_HEADERS_ALL';

9156: l_table := 'LNS_LOAN_HEADERS_ALL';
9157:
9158: elsif l_loan_status = 'INCOMPLETE' then
9159: l_column := 'REQUESTED_AMOUNT';
9160: l_table := 'LNS_LOAN_HEADERS_ALL';
9161:
9162: elsif l_loan_status = 'IN_FUNDING' then
9163: l_column := 'REQUESTED_AMOUNT';
9164: l_table := 'LNS_LOAN_HEADERS_ALL';

Line 9164: l_table := 'LNS_LOAN_HEADERS_ALL';

9160: l_table := 'LNS_LOAN_HEADERS_ALL';
9161:
9162: elsif l_loan_status = 'IN_FUNDING' then
9163: l_column := 'REQUESTED_AMOUNT';
9164: l_table := 'LNS_LOAN_HEADERS_ALL';
9165:
9166: elsif l_loan_status = 'FUNDING_ERROR' then
9167: l_column := 'REQUESTED_AMOUNT';
9168: l_table := 'LNS_LOAN_HEADERS_ALL';

Line 9168: l_table := 'LNS_LOAN_HEADERS_ALL';

9164: l_table := 'LNS_LOAN_HEADERS_ALL';
9165:
9166: elsif l_loan_status = 'FUNDING_ERROR' then
9167: l_column := 'REQUESTED_AMOUNT';
9168: l_table := 'LNS_LOAN_HEADERS_ALL';
9169:
9170: else -- catch any new statuses
9171: l_column := 'REQUESTED_AMOUNT';
9172: l_table := 'LNS_LOAN_HEADERS_ALL';

Line 9172: l_table := 'LNS_LOAN_HEADERS_ALL';

9168: l_table := 'LNS_LOAN_HEADERS_ALL';
9169:
9170: else -- catch any new statuses
9171: l_column := 'REQUESTED_AMOUNT';
9172: l_table := 'LNS_LOAN_HEADERS_ALL';
9173:
9174: end if;
9175:
9176: Execute Immediate