eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_LOAN_PUB dependencies on LNS_LOAN_PRODUCT_FLAGS

Line 134: FROM LNS_LOAN_PRODUCT_FLAGS

130: ,LOAN_PAYMENT_FREQUENCY_TBL.flag LOAN_PAYMENT_FREQ_OVR
131: ,LOAN_SUBTYPE_TBL.flag LOAN_SUBTYPE_OVR
132: ,REAMORTIZE_OVER_PAYMENT_TBL.flag REAMORTIZE_OVER_PAYMENT_OVR
133: FROM (SELECT DECODE(COUNT(*),0,'Y','N') flag
134: FROM LNS_LOAN_PRODUCT_FLAGS
135: WHERE loan_product_id = p_product_id
136: AND READONLY_COLUMN_NAME = 'LEGAL_ENTITY_ID'
137: ) LEGAL_ENTITY_ID_TBL,
138: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 139: FROM LNS_LOAN_PRODUCT_FLAGS

135: WHERE loan_product_id = p_product_id
136: AND READONLY_COLUMN_NAME = 'LEGAL_ENTITY_ID'
137: ) LEGAL_ENTITY_ID_TBL,
138: (SELECT DECODE(COUNT(*),0,'Y','N') flag
139: FROM LNS_LOAN_PRODUCT_FLAGS
140: WHERE loan_product_id = p_product_id
141: AND READONLY_COLUMN_NAME = 'LOAN_TERM'
142: ) LOAN_TERM_TBL,
143: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 144: FROM LNS_LOAN_PRODUCT_FLAGS

140: WHERE loan_product_id = p_product_id
141: AND READONLY_COLUMN_NAME = 'LOAN_TERM'
142: ) LOAN_TERM_TBL,
143: (SELECT DECODE(COUNT(*),0,'Y','N') flag
144: FROM LNS_LOAN_PRODUCT_FLAGS
145: WHERE loan_product_id = p_product_id
146: AND READONLY_COLUMN_NAME = 'LOAN_TERM_PERIOD'
147: ) LOAN_TERM_PERIOD_TBL,
148: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 149: FROM LNS_LOAN_PRODUCT_FLAGS

145: WHERE loan_product_id = p_product_id
146: AND READONLY_COLUMN_NAME = 'LOAN_TERM_PERIOD'
147: ) LOAN_TERM_PERIOD_TBL,
148: (SELECT DECODE(COUNT(*),0,'Y','N') flag
149: FROM LNS_LOAN_PRODUCT_FLAGS
150: WHERE loan_product_id = p_product_id
151: AND READONLY_COLUMN_NAME = 'INDEX_RATE_ID'
152: ) INDEX_RATE_ID_TBL,
153: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 154: FROM LNS_LOAN_PRODUCT_FLAGS

150: WHERE loan_product_id = p_product_id
151: AND READONLY_COLUMN_NAME = 'INDEX_RATE_ID'
152: ) INDEX_RATE_ID_TBL,
153: (SELECT DECODE(COUNT(*),0,'Y','N') flag
154: FROM LNS_LOAN_PRODUCT_FLAGS
155: WHERE loan_product_id = p_product_id
156: AND READONLY_COLUMN_NAME = 'RATE_TYPE'
157: ) RATE_TYPE_TBL,
158: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 159: FROM LNS_LOAN_PRODUCT_FLAGS

155: WHERE loan_product_id = p_product_id
156: AND READONLY_COLUMN_NAME = 'RATE_TYPE'
157: ) RATE_TYPE_TBL,
158: (SELECT DECODE(COUNT(*),0,'Y','N') flag
159: FROM LNS_LOAN_PRODUCT_FLAGS
160: WHERE loan_product_id = p_product_id
161: AND READONLY_COLUMN_NAME = 'INTEREST_COMPOUNDING_FREQ'
162: ) INTEREST_COMPOUNDING_FREQ_TBL,
163: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 164: FROM LNS_LOAN_PRODUCT_FLAGS

160: WHERE loan_product_id = p_product_id
161: AND READONLY_COLUMN_NAME = 'INTEREST_COMPOUNDING_FREQ'
162: ) INTEREST_COMPOUNDING_FREQ_TBL,
163: (SELECT DECODE(COUNT(*),0,'Y','N') flag
164: FROM LNS_LOAN_PRODUCT_FLAGS
165: WHERE loan_product_id = p_product_id
166: AND READONLY_COLUMN_NAME = 'OPEN_SPREAD'
167: ) OPEN_SPREAD_TBL,
168: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 169: FROM LNS_LOAN_PRODUCT_FLAGS

165: WHERE loan_product_id = p_product_id
166: AND READONLY_COLUMN_NAME = 'OPEN_SPREAD'
167: ) OPEN_SPREAD_TBL,
168: (SELECT DECODE(COUNT(*),0,'Y','N') flag
169: FROM LNS_LOAN_PRODUCT_FLAGS
170: WHERE loan_product_id = p_product_id
171: AND READONLY_COLUMN_NAME = 'OPEN_FLOOR_RATE'
172: ) OPEN_FLOOR_RATE_TBL,
173: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 174: FROM LNS_LOAN_PRODUCT_FLAGS

170: WHERE loan_product_id = p_product_id
171: AND READONLY_COLUMN_NAME = 'OPEN_FLOOR_RATE'
172: ) OPEN_FLOOR_RATE_TBL,
173: (SELECT DECODE(COUNT(*),0,'Y','N') flag
174: FROM LNS_LOAN_PRODUCT_FLAGS
175: WHERE loan_product_id = p_product_id
176: AND READONLY_COLUMN_NAME = 'OPEN_CEILING_RATE'
177: ) OPEN_CEILING_RATE_TBL,
178: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 179: FROM LNS_LOAN_PRODUCT_FLAGS

175: WHERE loan_product_id = p_product_id
176: AND READONLY_COLUMN_NAME = 'OPEN_CEILING_RATE'
177: ) OPEN_CEILING_RATE_TBL,
178: (SELECT DECODE(COUNT(*),0,'Y','N') flag
179: FROM LNS_LOAN_PRODUCT_FLAGS
180: WHERE loan_product_id = p_product_id
181: AND READONLY_COLUMN_NAME = 'OPEN_PERCENT_INCREASE'
182: ) OPEN_PERCENT_INCREASE_TBL,
183: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 184: FROM LNS_LOAN_PRODUCT_FLAGS

180: WHERE loan_product_id = p_product_id
181: AND READONLY_COLUMN_NAME = 'OPEN_PERCENT_INCREASE'
182: ) OPEN_PERCENT_INCREASE_TBL,
183: (SELECT DECODE(COUNT(*),0,'Y','N') flag
184: FROM LNS_LOAN_PRODUCT_FLAGS
185: WHERE loan_product_id = p_product_id
186: AND READONLY_COLUMN_NAME = 'OPEN_PERCENT_INCREASE_LIFE'
187: ) OPEN_PERCENT_INCREASE_LIFE_TBL,
188: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 189: FROM LNS_LOAN_PRODUCT_FLAGS

185: WHERE loan_product_id = p_product_id
186: AND READONLY_COLUMN_NAME = 'OPEN_PERCENT_INCREASE_LIFE'
187: ) OPEN_PERCENT_INCREASE_LIFE_TBL,
188: (SELECT DECODE(COUNT(*),0,'Y','N') flag
189: FROM LNS_LOAN_PRODUCT_FLAGS
190: WHERE loan_product_id = p_product_id
191: AND READONLY_COLUMN_NAME = 'SPREAD'
192: ) SPREAD_TBL,
193: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 194: FROM LNS_LOAN_PRODUCT_FLAGS

190: WHERE loan_product_id = p_product_id
191: AND READONLY_COLUMN_NAME = 'SPREAD'
192: ) SPREAD_TBL,
193: (SELECT DECODE(COUNT(*),0,'Y','N') flag
194: FROM LNS_LOAN_PRODUCT_FLAGS
195: WHERE loan_product_id = p_product_id
196: AND READONLY_COLUMN_NAME = 'FLOOR_RATE'
197: ) FLOOR_RATE_TBL,
198: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 199: FROM LNS_LOAN_PRODUCT_FLAGS

195: WHERE loan_product_id = p_product_id
196: AND READONLY_COLUMN_NAME = 'FLOOR_RATE'
197: ) FLOOR_RATE_TBL,
198: (SELECT DECODE(COUNT(*),0,'Y','N') flag
199: FROM LNS_LOAN_PRODUCT_FLAGS
200: WHERE loan_product_id = p_product_id
201: AND READONLY_COLUMN_NAME = 'CEILING_RATE'
202: ) CEILING_RATE_TBL,
203: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 204: FROM LNS_LOAN_PRODUCT_FLAGS

200: WHERE loan_product_id = p_product_id
201: AND READONLY_COLUMN_NAME = 'CEILING_RATE'
202: ) CEILING_RATE_TBL,
203: (SELECT DECODE(COUNT(*),0,'Y','N') flag
204: FROM LNS_LOAN_PRODUCT_FLAGS
205: WHERE loan_product_id = p_product_id
206: AND READONLY_COLUMN_NAME = 'PERCENT_INCREASE'
207: ) PERCENT_INCREASE_TBL,
208: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 209: FROM LNS_LOAN_PRODUCT_FLAGS

205: WHERE loan_product_id = p_product_id
206: AND READONLY_COLUMN_NAME = 'PERCENT_INCREASE'
207: ) PERCENT_INCREASE_TBL,
208: (SELECT DECODE(COUNT(*),0,'Y','N') flag
209: FROM LNS_LOAN_PRODUCT_FLAGS
210: WHERE loan_product_id = p_product_id
211: AND READONLY_COLUMN_NAME = 'PERCENT_INCREASE_LIFE'
212: ) PERCENT_INCREASE_LIFE_TBL,
213: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 214: FROM LNS_LOAN_PRODUCT_FLAGS

210: WHERE loan_product_id = p_product_id
211: AND READONLY_COLUMN_NAME = 'PERCENT_INCREASE_LIFE'
212: ) PERCENT_INCREASE_LIFE_TBL,
213: (SELECT DECODE(COUNT(*),0,'Y','N') flag
214: FROM LNS_LOAN_PRODUCT_FLAGS
215: WHERE loan_product_id = p_product_id
216: AND READONLY_COLUMN_NAME = 'LOAN_PAYMENT_FREQUENCY'
217: ) LOAN_PAYMENT_FREQUENCY_TBL,
218: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 219: FROM LNS_LOAN_PRODUCT_FLAGS

215: WHERE loan_product_id = p_product_id
216: AND READONLY_COLUMN_NAME = 'LOAN_PAYMENT_FREQUENCY'
217: ) LOAN_PAYMENT_FREQUENCY_TBL,
218: (SELECT DECODE(COUNT(*),0,'Y','N') flag
219: FROM LNS_LOAN_PRODUCT_FLAGS
220: WHERE loan_product_id = p_product_id
221: AND READONLY_COLUMN_NAME = 'LOAN_SUBTYPE'
222: ) LOAN_SUBTYPE_TBL,
223: (SELECT DECODE(COUNT(*),0,'Y','N') flag

Line 224: FROM LNS_LOAN_PRODUCT_FLAGS

220: WHERE loan_product_id = p_product_id
221: AND READONLY_COLUMN_NAME = 'LOAN_SUBTYPE'
222: ) LOAN_SUBTYPE_TBL,
223: (SELECT DECODE(COUNT(*),0,'Y','N') flag
224: FROM LNS_LOAN_PRODUCT_FLAGS
225: WHERE loan_product_id = p_product_id
226: AND READONLY_COLUMN_NAME = 'REAMORTIZE_OVER_PAYMENT'
227: ) REAMORTIZE_OVER_PAYMENT_TBL;
228: l_override_rec Csr_override_flags%ROWTYPE;