[Home] [Help]
1424: -- get payment application order
1425: CURSOR order_cur(P_LOAN_ID number) IS
1426: select PAYMENT_APPLICATION_ORDER,
1427: nvl(PMT_APPL_ORDER_SCOPE, 'ACROSS_INSTALLMENTS')
1428: from lns_terms
1429: where loan_id = P_LOAN_ID;
1430:
1431: -- get all amortizations
1432: CURSOR am_scheds_cur(P_LOAN_ID number) IS