APPS.CTO_WORKBENCH_UTIL_PK dependencies on MFG_LOOKUPS

Line 197: from mfg_lookups

193: IF (l_result <> 0) THEN
194: l_result := 7;
195: select meaning
196: into x_result
197: from mfg_lookups
198: where lookup_type = 'CTO_WB_SUPPLY_TYPE'
199: and lookup_code = l_result;
200:
201: return x_result;

Line 209: from mfg_lookups

205: END IF;
206:
207: select meaning
208: into x_result
209: from mfg_lookups
210: where lookup_type = 'CTO_WB_SUPPLY_TYPE'
211: and lookup_code = l_result;
212:
213: --

Line 249: from mfg_lookups

245: IF (l_result <> 0) THEN
246: l_result := 7;
247: select meaning
248: into x_result
249: from mfg_lookups
250: where lookup_type = 'CTO_WB_SUPPLY_TYPE'
251: and lookup_code = l_result;
252:
253: return x_result;

Line 273: from mfg_lookups

269: IF (l_result <> 0) THEN
270: l_result := 7;
271: select meaning
272: into x_result
273: from mfg_lookups
274: where lookup_type = 'CTO_WB_SUPPLY_TYPE'
275: and lookup_code = l_result;
276:
277: return x_result;

Line 297: from mfg_lookups

293: IF (l_result <> 0) THEN
294: l_result := 7;
295: select meaning
296: into x_result
297: from mfg_lookups
298: where lookup_type = 'CTO_WB_SUPPLY_TYPE'
299: and lookup_code = l_result;
300:
301: return x_result;

Line 322: from mfg_lookups

318: IF (l_result <> 0) THEN
319: l_result := 7;
320: select meaning
321: into x_result
322: from mfg_lookups
323: where lookup_type = 'CTO_WB_SUPPLY_TYPE'
324: and lookup_code = l_result;
325:
326: return x_result;

Line 347: from mfg_lookups

343: IF (l_result <> 0) THEN
344: l_result := 7;
345: select meaning
346: into x_result
347: from mfg_lookups
348: where lookup_type = 'CTO_WB_SUPPLY_TYPE'
349: and lookup_code = l_result;
350:
351: return x_result;

Line 359: from mfg_lookups

355: END IF;
356:
357: select meaning
358: into x_result
359: from mfg_lookups
360: where lookup_type = 'CTO_WB_SUPPLY_TYPE'
361: and lookup_code = l_result;
362:
363: END IF; /* internal source type */