APPS.LNS_LOAN_PUB dependencies on DUAL

Line 1101: from dual;

1097: -- HEADERS
1098: -- LOAN_ID
1099: select LNS_LOAN_HEADERS_S.nextval
1100: into g_loan_rec.loan_id
1101: from dual;
1102: /* Not needed since LNS_LOAN_HEADER_PUB API will be used for inserting
1103: -- Who Columns
1104: g_loan_rec.last_update_date := sysdate;
1105: g_loan_rec.last_updated_by := -1;

Line 1116: from dual;

1112:
1113: IF l_generate_loan_number = 'Y' THEN
1114: select 'L' || LNS_LOAN_NUMBER_S.nextval
1115: into g_loan_rec.loan_number
1116: from dual;
1117: END IF;
1118:
1119: g_loan_rec.requested_amount :=
1120: CASE l_product_rec.loan_class_code

Line 1272: from dual;

1268: g_term_rec.loan_id := g_loan_rec.loan_id;
1269:
1270: select LNS_TERMS_S.nextval
1271: into g_term_rec.term_id
1272: from dual;
1273:
1274: g_term_rec.rate_type := l_product_rec.rate_type;
1275: g_term_rec.index_rate_id := CASE l_override_rec.index_rate_id_ovr
1276: WHEN 'Y' THEN nvl(P_Loan_Details_Rec.index_rate_id,

Line 1395: FROM dual;

1391: g_rate_term_rec.term_id := g_term_rec.term_id;
1392:
1393: SELECT LNS_RATE_SCHEDULES_S.nextval
1394: INTO g_rate_term_rec.rate_id
1395: FROM dual;
1396:
1397: g_rate_term_rec.index_rate := P_Loan_Details_Rec.term_index_rate;
1398: g_rate_term_rec.spread := CASE l_override_rec.spread_ovr
1399: WHEN 'Y' THEN nvl(P_Loan_Details_Rec.term_spread,

Line 1428: FROM dual;

1424: g_rate_open_rec.term_id := g_term_rec.term_id;
1425:
1426: SELECT LNS_RATE_SCHEDULES_S.nextval
1427: INTO g_rate_open_rec.rate_id
1428: FROM dual;
1429:
1430: g_rate_open_rec.index_rate := P_Loan_Details_Rec.open_index_rate;
1431: g_rate_open_rec.spread := CASE l_override_rec.open_spread_ovr
1432: WHEN 'Y' THEN nvl(P_Loan_Details_Rec.open_spread,