APPS.LNS_PAYOFF_PUB dependencies on DUAL

Line 2394: select LNS_LOAN_CANCELLATIONS_S.NEXTVAL into p_LOAN_CANCELLATION_ID from dual;

2390: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_description = ' || l_description);
2391:
2392: if p_action = 'INSERT' then
2393: if p_LOAN_CANCELLATION_ID is null then
2394: select LNS_LOAN_CANCELLATIONS_S.NEXTVAL into p_LOAN_CANCELLATION_ID from dual;
2395: end if;
2396:
2397: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Inserting into LNS_LOAN_CANCELLATIONS...');
2398: insert into LNS_LOAN_CANCELLATIONS

Line 2463: select LNS_LOAN_CANCEL_DETAILS_S.NEXTVAL into l_LOAN_CANCEL_DETAIL_ID from dual;

2459: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ACTION = ' || p_cancel_details_tbl(i).ACTION);
2460:
2461: if p_action = 'INSERT' then
2462: if p_cancel_details_tbl(i).LOAN_CANCEL_DETAIL_ID is null then
2463: select LNS_LOAN_CANCEL_DETAILS_S.NEXTVAL into l_LOAN_CANCEL_DETAIL_ID from dual;
2464: p_cancel_details_tbl(i).LOAN_CANCEL_DETAIL_ID := l_LOAN_CANCEL_DETAIL_ID;
2465: end if;
2466:
2467: p_cancel_details_tbl(i).REMAINING_AMOUNT := round(p_cancel_details_tbl(i).REMAINING_AMOUNT, l_precision);