421: ) return varchar2 IS
422:
423: CURSOR c IS
424: SELECT meaning
425: FROM mfg_lookups
426: WHERE lookup_type = 'SYS_YES_NO'
427: AND lookup_code = X_Lookup_Code;
428:
429: BEGIN
465: BEGIN
466:
467: SELECT meaning
468: INTO L_Return_Value
469: FROM mfg_lookups
470: WHERE lookup_type = 'MTL_LOCATION_CONTROL'
471: AND lookup_code = X_Lookup_Code;
472:
473: RETURN ( L_Return_Value );