APPS.LNS_BILLING_BATCH_PUB dependencies on DUAL

Line 1083: from dual;

1079:
1080: /* generate new trx number */
1081: CURSOR new_trx_num_cur IS
1082: select LNS_TRX_NUMBER_S.NEXTVAL
1083: from dual;
1084:
1085: /* query of meaning of PAYMENT_APPLICATION_TYPE */
1086: CURSOR meaning_cur(P_LOOKUP_CODE varchar2) IS
1087: select meaning

Line 1305: select LNS_AMORTIZATION_SCHEDS_S.NEXTVAL into P_LOAN_REC.NEXT_AMORTIZATION_ID from dual;

1301: -- fix for bug 5840180: get LNS_CREATE_ZERO_PRIN_INV profile value to see if we need to bill 0 amount principal invoices
1302: l_bill_0_prin_inv := NVL(FND_PROFILE.VALUE('LNS_CREATE_ZERO_PRIN_INV'), 'N');
1303: LogMessage(FND_LOG.LEVEL_STATEMENT, 'The profile LNS_CREATE_ZERO_PRIN_INV value is : '||l_bill_0_prin_inv);
1304:
1305: select LNS_AMORTIZATION_SCHEDS_S.NEXTVAL into P_LOAN_REC.NEXT_AMORTIZATION_ID from dual;
1306:
1307: l_Count1 := 0; -- lines counter
1308: l_Count2 := 0; -- distributions counter
1309: l_Count3 := 0; -- header counter