DBA Data[Home] [Help]

APPS.LNS_FIN_UTILS dependencies on LNS_CUSTOM_PAYMNT_SCHEDS

Line 1413: from LNS_CUSTOM_PAYMNT_SCHEDS

1409: h.loan_id = t.loan_id;
1410:
1411: cursor c_num_cust_instal (p_loan_id NUMBER) is
1412: select nvl(max(PAYMENT_NUMBER), 1)
1413: from LNS_CUSTOM_PAYMNT_SCHEDS
1414: where loan_id = p_loan_id;
1415:
1416: begin
1417:

Line 1526: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Getting number of installments from LNS_CUSTOM_PAYMNT_SCHEDS...');

1522:
1523: else
1524:
1525: -- Fixed bug 6133313
1526: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Getting number of installments from LNS_CUSTOM_PAYMNT_SCHEDS...');
1527: OPEN c_num_cust_instal(p_loan_id);
1528: FETCH c_num_cust_instal INTO l_installments;
1529: close c_num_cust_instal;
1530:

Line 2422: from LNS_CUSTOM_PAYMNT_SCHEDS

2418: h.loan_id = t.loan_id;
2419:
2420: cursor c_num_cust_instal (p_loan_id NUMBER) is
2421: select nvl(max(PAYMENT_NUMBER), 1)
2422: from LNS_CUSTOM_PAYMNT_SCHEDS
2423: where loan_id = p_loan_id;
2424:
2425: begin
2426: