APPS.LNS_CUSTOM_PUB dependencies on LNS_AMORTIZATION_SCHEDS

Line 614: from lns_amortization_scheds

610: /* destroy records already billed
611: */
612: cursor c_records_to_destroy (p_loan_id number) is
613: select count(1)
614: from lns_amortization_scheds
615: where reamortization_amount is null
616: and reversed_flag <> 'Y'
617: and loan_id = p_loan_id
618: and payment_number > 0

Line 819: ' From lns_amortization_scheds ' ||

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

Line 1497: from lns_amortization_scheds

1493:
1494: -- cursor to get last bill due date
1495: cursor c_due_date(p_loan_id NUMBER) IS
1496: select trunc(max(DUE_DATE))
1497: from lns_amortization_scheds
1498: where loan_id = p_loan_id
1499: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N')
1500: --and parent_amortization_id is null
1501: and REAMORTIZATION_AMOUNT is null

Line 3846: from lns_amortization_scheds

3842:
3843: -- cursor to get due_dates of already built installments
3844: cursor c_built_payments(p_loan_id NUMBER) IS
3845: select PAYMENT_NUMBER, DUE_DATE
3846: from lns_amortization_scheds
3847: where loan_id = p_loan_id
3848: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N')
3849: and parent_amortization_id is null
3850: and REAMORTIZATION_AMOUNT is null

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

3874:
3875: i := 1;
3876: if l_loan_details.LAST_INSTALLMENT_BILLED > 0 then
3877:
3878: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Loading dates from lns_amortization_scheds:');
3879: OPEN c_built_payments(p_loan_id);
3880: LOOP
3881:
3882: FETCH c_built_payments INTO l_payment_number, l_due_date;