DBA Data[Home] [Help]

APPS.WIP_PREFERENCES_PKG dependencies on MFG_LOOKUPS

Line 161: from mfg_lookups ml

157: l_value_code varchar2(240);
158:
159: cursor lookup_meaning (cl_value_code number) is
160: select ml.meaning
161: from mfg_lookups ml
162: where ml.lookup_code = to_number(cl_value_code) and
163: ml.lookup_type = (select wp.preference_value_lookup_type
164: from wip_preference_definitions wp
165: where wp.preference_id = p_preference_id);

Line 453: from mfg_lookups l

449: level varchar2(30);
450:
451: cursor l is
452: select l.meaning levelCode
453: from mfg_lookups l
454: where l.lookup_type = 'WIP_WS_PREF_LEVELS' and
455: l.lookup_code = p_level_code;
456:
457: begin