DBA Data[Home] [Help]

APPS.LNS_FEE_ENGINE dependencies on DUAL

Line 1657: from dual;

1653:
1654: i := 0;
1655: select LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT(p_loan_id) + 1
1656: into l_last_installment
1657: from dual;
1658:
1659: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_installment is: ' || p_installment);
1660: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_based_on_terms: ' || p_based_on_terms);
1661: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee_basis passed is: ' || p_fee_basis_tbl.count);

Line 2284: from dual;

2280: end if; -- disb_header_id
2281: --
2282: select lns_fee_schedule_s.nextval
2283: into l_fee_schedule_id
2284: from dual;
2285:
2286: -- fee structure has been validated write to the fee schedule
2287: LNS_FEE_SCHEDULES_PKG.INSERT_ROW(X_FEE_SCHEDULE_ID => l_fee_schedule_id
2288: ,P_FEE_ID => p_fees_tbl(k).FEE_ID

Line 2892: from dual;

2888: --3. write to fee schedule
2889: i := 0;
2890: select LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT(p_loan_id)
2891: into l_last_installment
2892: from dual;
2893:
2894: if l_last_installment > 0 then
2895:
2896: -- first part is for TERM PHASE