APPS.LNS_CUSTOM_PUB dependencies on LNS_AMORTIZATION_SCHEDS

Line 619: from lns_amortization_scheds

615: /* destroy records already billed
616: */
617: cursor c_records_to_destroy (p_loan_id number) is
618: select count(1)
619: from lns_amortization_scheds
620: where reamortization_amount is null
621: and reversed_flag <> 'Y'
622: and loan_id = p_loan_id
623: and payment_number > 0

Line 824: ' From lns_amortization_scheds ' ||

820: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'in update validation');
821: -- here i need to know only the number of rows that have not been billed
822: Execute Immediate
823: ' Select count(1) ' ||
824: ' From lns_amortization_scheds ' ||
825: ' where loan_id = :p_loan_id ' ||
826: ' and reversed_flag <> ''Y'' ' ||
827: ' and reamortization_amount is null ' ||
828: ' and payment_number > 0 ' ||

Line 1660: from lns_amortization_scheds

1656:
1657: -- cursor to get last bill due date
1658: cursor c_due_date(p_loan_id NUMBER) IS
1659: select trunc(max(DUE_DATE))
1660: from lns_amortization_scheds
1661: where loan_id = p_loan_id
1662: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N')
1663: and parent_amortization_id is null
1664: and REAMORTIZATION_AMOUNT is null

Line 2225: from LNS_AMORTIZATION_SCHEDS

2221: and ACTIVITY_CODE in ('BILLING', 'START');
2222:
2223: cursor c_get_funded_amount(p_loan_id number, p_installment_number number) is
2224: select FUNDED_AMOUNT, nvl(DEFERRED_INT_AMOUNT, 0), nvl(CAP_INT_AMOUNT, 0)
2225: from LNS_AMORTIZATION_SCHEDS
2226: where loan_id = p_loan_id
2227: and PAYMENT_NUMBER = p_installment_number
2228: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N')
2229: and PARENT_AMORTIZATION_ID is null

Line 3529: FROM lns_amortization_scheds am,

3525:
3526: CURSOR last_billed_due_date_cur(P_LOAN_ID NUMBER) IS
3527: SELECT trunc(max(DUE_DATE)),
3528: max(term.first_payment_date)
3529: FROM lns_amortization_scheds am,
3530: lns_loan_headers_all loan,
3531: lns_terms term
3532: WHERE loan.loan_id = P_LOAN_ID
3533: AND loan.loan_id = term.loan_id

Line 4658: from lns_amortization_scheds

4654:
4655: -- cursor to get due_dates of already built installments
4656: cursor c_built_payments(p_loan_id NUMBER) IS
4657: select PAYMENT_NUMBER, DUE_DATE
4658: from lns_amortization_scheds
4659: where loan_id = p_loan_id
4660: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N')
4661: and parent_amortization_id is null
4662: and REAMORTIZATION_AMOUNT is null

Line 4690: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Loading dates from lns_amortization_scheds:');

4686:
4687: i := 1;
4688: if l_loan_details.LAST_INSTALLMENT_BILLED > 0 then
4689:
4690: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Loading dates from lns_amortization_scheds:');
4691: OPEN c_built_payments(p_loan_id);
4692: LOOP
4693:
4694: FETCH c_built_payments INTO l_payment_number, l_due_date;