411: ) return varchar2 IS
412:
413: CURSOR c IS
414: SELECT meaning 415: FROM mfg_lookups 416: WHERE lookup_type = 'SYS_YES_NO'
417: AND lookup_code = X_Lookup_Code;
418:
419: BEGIN
Line 459: FROM mfg_lookups
455: BEGIN
456:
457: SELECT meaning
458: INTO L_Return_Value 459: FROM mfg_lookups 460: WHERE lookup_type = 'MTL_LOCATION_CONTROL'
461: AND lookup_code = X_Lookup_Code;
462:
463: RETURN ( L_Return_Value );