APPS.EDW_DUNS_M_C dependencies on FND_LOOKUPS

Line 177: from fnd_lookups fnd

173: For lfailure in c_dnb_failure loop
174: Update POA_TPRT_INTERFACE dnb
175: set (FAILURE_VALUE) =
176: (select Description
177: from fnd_lookups fnd
178: where ((fnd.lookup_code = lfailure.FAILURE_IND) and
179: (fnd.lookup_type = 'POA_DNB_FAILURE_IND')))
180: where (dnb.FAILURE_IND = lfailure.FAILURE_IND);
181: end loop;

Line 192: from fnd_lookups fnd

188: For lhigh_risk in c_dnb_high_risk loop
189: Update POA_TPRT_INTERFACE dnb
190: set (HIGH_RISK_VALUE) =
191: (select Description
192: from fnd_lookups fnd
193: where ((fnd.lookup_code = lhigh_risk.HIGH_RISK_INDCATOR) and
194: (fnd.lookup_type = 'POA_DNB_HIGH_RISK_IND')))
195: where (dnb.HIGH_RISK_INDCATOR = lhigh_risk.HIGH_RISK_INDCATOR);
196: end loop;

Line 207: from fnd_lookups fnd

203: For lminority_owned in c_dnb_minority_owned loop
204: Update POA_TPRT_INTERFACE dnb
205: set (MINORITY_OWNED_VALUE) =
206: (select Description
207: from fnd_lookups fnd
208: where ((fnd.lookup_code = lminority_owned.MINORITY_OWNED_IND) and
209: (fnd.lookup_type = 'POA_DNB_MINORITY_OWNED_TYPE')))
210: where (dnb.MINORITY_OWNED_IND = lminority_owned.MINORITY_OWNED_IND);
211: end loop;

Line 222: from fnd_lookups fnd

218: For lcurrent_statement in c_dnb_current_statement loop
219: Update POA_TPRT_INTERFACE dnb
220: set (CURRENT_STATEMENT_VALUE) =
221: (select Description
222: from fnd_lookups fnd
223: where ((fnd.lookup_code =
224: lcurrent_statement.CURRENT_STATEMENT_TYPE) and
225: (fnd.lookup_type = 'POA_DNB_CURRENT_STMT_TYPE')))
226: where (dnb.CURRENT_STATEMENT_TYPE =

Line 239: from fnd_lookups fnd

235: For llegal_status in c_dnb_legal_status loop
236: Update POA_TPRT_INTERFACE dnb
237: set (LEGAL_STATUS_VALUE) =
238: (select Description
239: from fnd_lookups fnd
240: where ((fnd.lookup_code = llegal_status.LEGAL_STATUS) and
241: (fnd.lookup_type = 'POA_DNB_LEGAL_STATUS')))
242: where (dnb.LEGAL_STATUS = llegal_status.LEGAL_STATUS);
243: end loop;

Line 254: from fnd_lookups fnd

250: For lfire_disaster in c_dnb_fire_disaster loop
251: Update POA_TPRT_INTERFACE dnb
252: set (FIRE_DISASTER_VALUE) =
253: (select Description
254: from fnd_lookups fnd
255: where ((fnd.lookup_code = lfire_disaster.FIRE_DISASTER_IND) and
256: (fnd.lookup_type = 'POA_DNB_FIRE_DISASTER_IND')))
257: where (dnb.FIRE_DISASTER_IND = lfire_disaster.FIRE_DISASTER_IND);
258: end loop;

Line 269: from fnd_lookups fnd

265: For lowns_rents in c_dnb_owns_rents loop
266: Update POA_TPRT_INTERFACE dnb
267: set (OWNS_RENTS_VALUE) =
268: (select Description
269: from fnd_lookups fnd
270: where ((fnd.lookup_code = lowns_rents.OWNS_RENTS_IND) and
271: (fnd.lookup_type = 'POA_DNB_OWNS_RENTS_IND')))
272: where (dnb.OWNS_RENTS_IND = lowns_rents.OWNS_RENTS_IND);
273: end loop;

Line 284: from fnd_lookups fnd

280: For lhistory in c_dnb_history loop
281: Update POA_TPRT_INTERFACE dnb
282: set (HISTORY_VALUE) =
283: (select Description
284: from fnd_lookups fnd
285: where ((fnd.lookup_code = lhistory.HISTORY) and
286: (fnd.lookup_type = 'POA_DNB_HISTORY_IND')))
287: where (dnb.HISTORY = lhistory.HISTORY);
288: end loop;

Line 299: from fnd_lookups fnd

295: For llocation_status in c_dnb_location_status loop
296: Update POA_TPRT_INTERFACE dnb
297: set (LOCATION_STATUS_VALUE) =
298: (select Description
299: from fnd_lookups fnd
300: where ((fnd.lookup_code = llocation_status.LOCATION_STATUS_IND) and
301: (fnd.lookup_type = 'POA_DNB_LOCATION_STATUS')))
302: where (dnb.LOCATION_STATUS_IND = llocation_status.LOCATION_STATUS_IND);
303: end loop;

Line 314: from fnd_lookups fnd

310: For loob in c_dnb_oob loop
311: Update POA_TPRT_INTERFACE dnb
312: set (OOB_VALUE) =
313: (select Description
314: from fnd_lookups fnd
315: where ((fnd.lookup_code = loob.OOB_IND) and
316: (fnd.lookup_type = 'POA_DNB_OOB_IND')))
317: where (dnb.OOB_IND = loob.OOB_IND);
318: end loop;

Line 329: from fnd_lookups fnd

325: For lcriminal_proceedings in c_dnb_criminal_proceedings loop
326: Update POA_TPRT_INTERFACE dnb
327: set (CRIMINAL_PROCEEDINGS_VALUE) =
328: (select Description
329: from fnd_lookups fnd
330: where ((fnd.lookup_code =
331: lcriminal_proceedings.CRIMINAL_PROCEEDINGS_IND) and
332: (fnd.lookup_type = 'POA_DNB_CRIMINAL_PROCDN_IND')))
333: where (dnb.CRIMINAL_PROCEEDINGS_IND =

Line 346: from fnd_lookups fnd

342: For lbankruptcy in c_dnb_bankruptcy loop
343: Update POA_TPRT_INTERFACE dnb
344: set (BANKRUPTCY_VALUE) =
345: (select Description
346: from fnd_lookups fnd
347: where ((fnd.lookup_code = lbankruptcy.BANKRUPTCY_IND) and
348: (fnd.lookup_type = 'POA_DNB_BANKRUPTCY_IND')))
349: where (dnb.BANKRUPTCY_IND = lbankruptcy.BANKRUPTCY_IND);
350: end loop;

Line 361: from fnd_lookups fnd

357: For lbusiness_moved in c_dnb_business_moved loop
358: Update POA_TPRT_INTERFACE dnb
359: set (BUSINESS_MOVED_VALUE) =
360: (select Description
361: from fnd_lookups fnd
362: where ((fnd.lookup_code = lbusiness_moved.BUSINESS_MOVED_IND) and
363: (fnd.lookup_type = 'POA_DNB_BUSINESS_MOVED_IND')))
364: where (dnb.BUSINESS_MOVED_IND = lbusiness_moved.BUSINESS_MOVED_IND);
365: end loop;