APPS.LNS_LOAN_PUB dependencies on LNS_LOAN_PRODUCT_FLAGS

Line 170: FROM LNS_LOAN_PRODUCT_FLAGS

166: ,CALC_ADD_INT_UNPAID_INT_TBL.flag CALC_ADD_INT_UNPAID_INT_OVR
167: ,REAMORTIZE_ON_FUNDING_TBL.flag REAMORTIZE_ON_FUNDING_OVR
168: ,CUSTOM_CALC_METHOD_TBL.flag CUSTOM_CALC_METHOD_OVR
169: FROM (SELECT DECODE(COUNT(*),0,'Y','N') flag
170: FROM LNS_LOAN_PRODUCT_FLAGS
171: WHERE loan_product_id = p_product_id
172: AND READONLY_COLUMN_NAME = 'LEGAL_ENTITY_ID'
173: ) LEGAL_ENTITY_ID_TBL,
174: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 175: FROM LNS_LOAN_PRODUCT_FLAGS

171: WHERE loan_product_id = p_product_id
172: AND READONLY_COLUMN_NAME = 'LEGAL_ENTITY_ID'
173: ) LEGAL_ENTITY_ID_TBL,
174: (SELECT DECODE(COUNT(*),0,'Y','N') flag
175: FROM LNS_LOAN_PRODUCT_FLAGS
176: WHERE loan_product_id = p_product_id
177: AND READONLY_COLUMN_NAME = 'LOAN_TERM'
178: ) LOAN_TERM_TBL,
179: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 180: FROM LNS_LOAN_PRODUCT_FLAGS

176: WHERE loan_product_id = p_product_id
177: AND READONLY_COLUMN_NAME = 'LOAN_TERM'
178: ) LOAN_TERM_TBL,
179: (SELECT DECODE(COUNT(*),0,'Y','N') flag
180: FROM LNS_LOAN_PRODUCT_FLAGS
181: WHERE loan_product_id = p_product_id
182: AND READONLY_COLUMN_NAME = 'LOAN_TERM_PERIOD'
183: ) LOAN_TERM_PERIOD_TBL,
184: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 185: FROM LNS_LOAN_PRODUCT_FLAGS

181: WHERE loan_product_id = p_product_id
182: AND READONLY_COLUMN_NAME = 'LOAN_TERM_PERIOD'
183: ) LOAN_TERM_PERIOD_TBL,
184: (SELECT DECODE(COUNT(*),0,'Y','N') flag
185: FROM LNS_LOAN_PRODUCT_FLAGS
186: WHERE loan_product_id = p_product_id
187: AND READONLY_COLUMN_NAME = 'INDEX_RATE_ID'
188: ) INDEX_RATE_ID_TBL,
189: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 190: FROM LNS_LOAN_PRODUCT_FLAGS

186: WHERE loan_product_id = p_product_id
187: AND READONLY_COLUMN_NAME = 'INDEX_RATE_ID'
188: ) INDEX_RATE_ID_TBL,
189: (SELECT DECODE(COUNT(*),0,'Y','N') flag
190: FROM LNS_LOAN_PRODUCT_FLAGS
191: WHERE loan_product_id = p_product_id
192: AND READONLY_COLUMN_NAME = 'RATE_TYPE'
193: ) RATE_TYPE_TBL,
194: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 195: FROM LNS_LOAN_PRODUCT_FLAGS

191: WHERE loan_product_id = p_product_id
192: AND READONLY_COLUMN_NAME = 'RATE_TYPE'
193: ) RATE_TYPE_TBL,
194: (SELECT DECODE(COUNT(*),0,'Y','N') flag
195: FROM LNS_LOAN_PRODUCT_FLAGS
196: WHERE loan_product_id = p_product_id
197: AND READONLY_COLUMN_NAME = 'INTEREST_COMPOUNDING_FREQ'
198: ) INTEREST_COMPOUNDING_FREQ_TBL,
199: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 200: FROM LNS_LOAN_PRODUCT_FLAGS

196: WHERE loan_product_id = p_product_id
197: AND READONLY_COLUMN_NAME = 'INTEREST_COMPOUNDING_FREQ'
198: ) INTEREST_COMPOUNDING_FREQ_TBL,
199: (SELECT DECODE(COUNT(*),0,'Y','N') flag
200: FROM LNS_LOAN_PRODUCT_FLAGS
201: WHERE loan_product_id = p_product_id
202: AND READONLY_COLUMN_NAME = 'OPEN_SPREAD'
203: ) OPEN_SPREAD_TBL,
204: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 205: FROM LNS_LOAN_PRODUCT_FLAGS

201: WHERE loan_product_id = p_product_id
202: AND READONLY_COLUMN_NAME = 'OPEN_SPREAD'
203: ) OPEN_SPREAD_TBL,
204: (SELECT DECODE(COUNT(*),0,'Y','N') flag
205: FROM LNS_LOAN_PRODUCT_FLAGS
206: WHERE loan_product_id = p_product_id
207: AND READONLY_COLUMN_NAME = 'OPEN_FLOOR_RATE'
208: ) OPEN_FLOOR_RATE_TBL,
209: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 210: FROM LNS_LOAN_PRODUCT_FLAGS

206: WHERE loan_product_id = p_product_id
207: AND READONLY_COLUMN_NAME = 'OPEN_FLOOR_RATE'
208: ) OPEN_FLOOR_RATE_TBL,
209: (SELECT DECODE(COUNT(*),0,'Y','N') flag
210: FROM LNS_LOAN_PRODUCT_FLAGS
211: WHERE loan_product_id = p_product_id
212: AND READONLY_COLUMN_NAME = 'OPEN_CEILING_RATE'
213: ) OPEN_CEILING_RATE_TBL,
214: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 215: FROM LNS_LOAN_PRODUCT_FLAGS

211: WHERE loan_product_id = p_product_id
212: AND READONLY_COLUMN_NAME = 'OPEN_CEILING_RATE'
213: ) OPEN_CEILING_RATE_TBL,
214: (SELECT DECODE(COUNT(*),0,'Y','N') flag
215: FROM LNS_LOAN_PRODUCT_FLAGS
216: WHERE loan_product_id = p_product_id
217: AND READONLY_COLUMN_NAME = 'OPEN_PERCENT_INCREASE'
218: ) OPEN_PERCENT_INCREASE_TBL,
219: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 220: FROM LNS_LOAN_PRODUCT_FLAGS

216: WHERE loan_product_id = p_product_id
217: AND READONLY_COLUMN_NAME = 'OPEN_PERCENT_INCREASE'
218: ) OPEN_PERCENT_INCREASE_TBL,
219: (SELECT DECODE(COUNT(*),0,'Y','N') flag
220: FROM LNS_LOAN_PRODUCT_FLAGS
221: WHERE loan_product_id = p_product_id
222: AND READONLY_COLUMN_NAME = 'OPEN_PERCENT_INCREASE_LIFE'
223: ) OPEN_PERCENT_INCREASE_LIFE_TBL,
224: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 225: FROM LNS_LOAN_PRODUCT_FLAGS

221: WHERE loan_product_id = p_product_id
222: AND READONLY_COLUMN_NAME = 'OPEN_PERCENT_INCREASE_LIFE'
223: ) OPEN_PERCENT_INCREASE_LIFE_TBL,
224: (SELECT DECODE(COUNT(*),0,'Y','N') flag
225: FROM LNS_LOAN_PRODUCT_FLAGS
226: WHERE loan_product_id = p_product_id
227: AND READONLY_COLUMN_NAME = 'SPREAD'
228: ) SPREAD_TBL,
229: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 230: FROM LNS_LOAN_PRODUCT_FLAGS

226: WHERE loan_product_id = p_product_id
227: AND READONLY_COLUMN_NAME = 'SPREAD'
228: ) SPREAD_TBL,
229: (SELECT DECODE(COUNT(*),0,'Y','N') flag
230: FROM LNS_LOAN_PRODUCT_FLAGS
231: WHERE loan_product_id = p_product_id
232: AND READONLY_COLUMN_NAME = 'FLOOR_RATE'
233: ) FLOOR_RATE_TBL,
234: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 235: FROM LNS_LOAN_PRODUCT_FLAGS

231: WHERE loan_product_id = p_product_id
232: AND READONLY_COLUMN_NAME = 'FLOOR_RATE'
233: ) FLOOR_RATE_TBL,
234: (SELECT DECODE(COUNT(*),0,'Y','N') flag
235: FROM LNS_LOAN_PRODUCT_FLAGS
236: WHERE loan_product_id = p_product_id
237: AND READONLY_COLUMN_NAME = 'CEILING_RATE'
238: ) CEILING_RATE_TBL,
239: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 240: FROM LNS_LOAN_PRODUCT_FLAGS

236: WHERE loan_product_id = p_product_id
237: AND READONLY_COLUMN_NAME = 'CEILING_RATE'
238: ) CEILING_RATE_TBL,
239: (SELECT DECODE(COUNT(*),0,'Y','N') flag
240: FROM LNS_LOAN_PRODUCT_FLAGS
241: WHERE loan_product_id = p_product_id
242: AND READONLY_COLUMN_NAME = 'PERCENT_INCREASE'
243: ) PERCENT_INCREASE_TBL,
244: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 245: FROM LNS_LOAN_PRODUCT_FLAGS

241: WHERE loan_product_id = p_product_id
242: AND READONLY_COLUMN_NAME = 'PERCENT_INCREASE'
243: ) PERCENT_INCREASE_TBL,
244: (SELECT DECODE(COUNT(*),0,'Y','N') flag
245: FROM LNS_LOAN_PRODUCT_FLAGS
246: WHERE loan_product_id = p_product_id
247: AND READONLY_COLUMN_NAME = 'PERCENT_INCREASE_LIFE'
248: ) PERCENT_INCREASE_LIFE_TBL,
249: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 250: FROM LNS_LOAN_PRODUCT_FLAGS

246: WHERE loan_product_id = p_product_id
247: AND READONLY_COLUMN_NAME = 'PERCENT_INCREASE_LIFE'
248: ) PERCENT_INCREASE_LIFE_TBL,
249: (SELECT DECODE(COUNT(*),0,'Y','N') flag
250: FROM LNS_LOAN_PRODUCT_FLAGS
251: WHERE loan_product_id = p_product_id
252: AND READONLY_COLUMN_NAME = 'LOAN_PAYMENT_FREQUENCY'
253: ) LOAN_PAYMENT_FREQUENCY_TBL,
254: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 255: FROM LNS_LOAN_PRODUCT_FLAGS

251: WHERE loan_product_id = p_product_id
252: AND READONLY_COLUMN_NAME = 'LOAN_PAYMENT_FREQUENCY'
253: ) LOAN_PAYMENT_FREQUENCY_TBL,
254: (SELECT DECODE(COUNT(*),0,'Y','N') flag
255: FROM LNS_LOAN_PRODUCT_FLAGS
256: WHERE loan_product_id = p_product_id
257: AND READONLY_COLUMN_NAME = 'LOAN_SUBTYPE'
258: ) LOAN_SUBTYPE_TBL,
259: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 260: FROM LNS_LOAN_PRODUCT_FLAGS

256: WHERE loan_product_id = p_product_id
257: AND READONLY_COLUMN_NAME = 'LOAN_SUBTYPE'
258: ) LOAN_SUBTYPE_TBL,
259: (SELECT DECODE(COUNT(*),0,'Y','N') flag
260: FROM LNS_LOAN_PRODUCT_FLAGS
261: WHERE loan_product_id = p_product_id
262: AND READONLY_COLUMN_NAME = 'REAMORTIZE_OVER_PAYMENT'
263: ) REAMORTIZE_OVER_PAYMENT_TBL,
264: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 265: FROM LNS_LOAN_PRODUCT_FLAGS

261: WHERE loan_product_id = p_product_id
262: AND READONLY_COLUMN_NAME = 'REAMORTIZE_OVER_PAYMENT'
263: ) REAMORTIZE_OVER_PAYMENT_TBL,
264: (SELECT DECODE(COUNT(*),0,'Y','N') flag
265: FROM LNS_LOAN_PRODUCT_FLAGS
266: WHERE loan_product_id = p_product_id
267: AND READONLY_COLUMN_NAME = 'DAY_COUNT_METHOD'
268: ) DAY_COUNT_METHOD_TBL,
269: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 270: FROM LNS_LOAN_PRODUCT_FLAGS

266: WHERE loan_product_id = p_product_id
267: AND READONLY_COLUMN_NAME = 'DAY_COUNT_METHOD'
268: ) DAY_COUNT_METHOD_TBL,
269: (SELECT DECODE(COUNT(*),0,'Y','N') flag
270: FROM LNS_LOAN_PRODUCT_FLAGS
271: WHERE loan_product_id = p_product_id
272: AND READONLY_COLUMN_NAME = 'INTEREST_CALCULATION_METHOD'
273: ) CALCULATION_METHOD_TBL,
274: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 275: FROM LNS_LOAN_PRODUCT_FLAGS

271: WHERE loan_product_id = p_product_id
272: AND READONLY_COLUMN_NAME = 'INTEREST_CALCULATION_METHOD'
273: ) CALCULATION_METHOD_TBL,
274: (SELECT DECODE(COUNT(*),0,'Y','N') flag
275: FROM LNS_LOAN_PRODUCT_FLAGS
276: WHERE loan_product_id = p_product_id
277: AND READONLY_COLUMN_NAME = 'RATE_CHANGE_FREQUENCY'
278: ) RATE_CHANGE_FREQUENCY_TBL,
279: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 280: FROM LNS_LOAN_PRODUCT_FLAGS

276: WHERE loan_product_id = p_product_id
277: AND READONLY_COLUMN_NAME = 'RATE_CHANGE_FREQUENCY'
278: ) RATE_CHANGE_FREQUENCY_TBL,
279: (SELECT DECODE(COUNT(*),0,'Y','N') flag
280: FROM LNS_LOAN_PRODUCT_FLAGS
281: WHERE loan_product_id = p_product_id
282: AND READONLY_COLUMN_NAME = 'COLLATERAL_PERCENT'
283: ) COLLATERAL_PERCENT_TBL,
284: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 285: FROM LNS_LOAN_PRODUCT_FLAGS

281: WHERE loan_product_id = p_product_id
282: AND READONLY_COLUMN_NAME = 'COLLATERAL_PERCENT'
283: ) COLLATERAL_PERCENT_TBL,
284: (SELECT DECODE(COUNT(*),0,'Y','N') flag
285: FROM LNS_LOAN_PRODUCT_FLAGS
286: WHERE loan_product_id = p_product_id
287: AND READONLY_COLUMN_NAME = 'FORGIVENESS_FLAG'
288: ) FORGIVENESS_FLAG_TBL,
289: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 290: FROM LNS_LOAN_PRODUCT_FLAGS

286: WHERE loan_product_id = p_product_id
287: AND READONLY_COLUMN_NAME = 'FORGIVENESS_FLAG'
288: ) FORGIVENESS_FLAG_TBL,
289: (SELECT DECODE(COUNT(*),0,'Y','N') flag
290: FROM LNS_LOAN_PRODUCT_FLAGS
291: WHERE loan_product_id = p_product_id
292: AND READONLY_COLUMN_NAME = 'FORGIVENESS_PERCENT'
293: ) FORGIVENESS_PERCENT_TBL,
294: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 295: FROM LNS_LOAN_PRODUCT_FLAGS

291: WHERE loan_product_id = p_product_id
292: AND READONLY_COLUMN_NAME = 'FORGIVENESS_PERCENT'
293: ) FORGIVENESS_PERCENT_TBL,
294: (SELECT DECODE(COUNT(*),0,'Y','N') flag
295: FROM LNS_LOAN_PRODUCT_FLAGS
296: WHERE loan_product_id = p_product_id
297: AND READONLY_COLUMN_NAME = 'PAYMENT_CALC_METHOD'
298: ) PAYMENT_CALC_METHOD_TBL,
299: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 300: FROM LNS_LOAN_PRODUCT_FLAGS

296: WHERE loan_product_id = p_product_id
297: AND READONLY_COLUMN_NAME = 'PAYMENT_CALC_METHOD'
298: ) PAYMENT_CALC_METHOD_TBL,
299: (SELECT DECODE(COUNT(*),0,'Y','N') flag
300: FROM LNS_LOAN_PRODUCT_FLAGS
301: WHERE loan_product_id = p_product_id
302: AND READONLY_COLUMN_NAME = 'PRINCIPAL_PAYMENT_FREQUENCY'
303: ) PRIN_PAYMENT_FREQUENCY_TBL,
304: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 305: FROM LNS_LOAN_PRODUCT_FLAGS

301: WHERE loan_product_id = p_product_id
302: AND READONLY_COLUMN_NAME = 'PRINCIPAL_PAYMENT_FREQUENCY'
303: ) PRIN_PAYMENT_FREQUENCY_TBL,
304: (SELECT DECODE(COUNT(*),0,'Y','N') flag
305: FROM LNS_LOAN_PRODUCT_FLAGS
306: WHERE loan_product_id = p_product_id
307: AND READONLY_COLUMN_NAME = 'PENAL_INT_RATE'
308: ) PENAL_INT_RATE_TBL,
309: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 310: FROM LNS_LOAN_PRODUCT_FLAGS

306: WHERE loan_product_id = p_product_id
307: AND READONLY_COLUMN_NAME = 'PENAL_INT_RATE'
308: ) PENAL_INT_RATE_TBL,
309: (SELECT DECODE(COUNT(*),0,'Y','N') flag
310: FROM LNS_LOAN_PRODUCT_FLAGS
311: WHERE loan_product_id = p_product_id
312: AND READONLY_COLUMN_NAME = 'PENAL_INT_GRACE_DAYS'
313: ) PENAL_INT_GRACE_DAYS_TBL,
314: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 315: FROM LNS_LOAN_PRODUCT_FLAGS

311: WHERE loan_product_id = p_product_id
312: AND READONLY_COLUMN_NAME = 'PENAL_INT_GRACE_DAYS'
313: ) PENAL_INT_GRACE_DAYS_TBL,
314: (SELECT DECODE(COUNT(*),0,'Y','N') flag
315: FROM LNS_LOAN_PRODUCT_FLAGS
316: WHERE loan_product_id = p_product_id
317: AND READONLY_COLUMN_NAME = 'CALC_ADD_INT_UNPAID_PRIN'
318: ) CALC_ADD_INT_UNPAID_PRIN_TBL,
319: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 320: FROM LNS_LOAN_PRODUCT_FLAGS

316: WHERE loan_product_id = p_product_id
317: AND READONLY_COLUMN_NAME = 'CALC_ADD_INT_UNPAID_PRIN'
318: ) CALC_ADD_INT_UNPAID_PRIN_TBL,
319: (SELECT DECODE(COUNT(*),0,'Y','N') flag
320: FROM LNS_LOAN_PRODUCT_FLAGS
321: WHERE loan_product_id = p_product_id
322: AND READONLY_COLUMN_NAME = 'CALC_ADD_INT_UNPAID_INT'
323: ) CALC_ADD_INT_UNPAID_INT_TBL,
324: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 325: FROM LNS_LOAN_PRODUCT_FLAGS

321: WHERE loan_product_id = p_product_id
322: AND READONLY_COLUMN_NAME = 'CALC_ADD_INT_UNPAID_INT'
323: ) CALC_ADD_INT_UNPAID_INT_TBL,
324: (SELECT DECODE(COUNT(*),0,'Y','N') flag
325: FROM LNS_LOAN_PRODUCT_FLAGS
326: WHERE loan_product_id = p_product_id
327: AND READONLY_COLUMN_NAME = 'REAMORTIZE_ON_FUNDING'
328: ) REAMORTIZE_ON_FUNDING_TBL,
329: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 330: FROM LNS_LOAN_PRODUCT_FLAGS

326: WHERE loan_product_id = p_product_id
327: AND READONLY_COLUMN_NAME = 'REAMORTIZE_ON_FUNDING'
328: ) REAMORTIZE_ON_FUNDING_TBL,
329: (SELECT DECODE(COUNT(*),0,'Y','N') flag
330: FROM LNS_LOAN_PRODUCT_FLAGS
331: WHERE loan_product_id = p_product_id
332: AND READONLY_COLUMN_NAME = 'CUSTOM_CALC_METHOD'
333: ) CUSTOM_CALC_METHOD_TBL;
334: