282: SELECT
283: MEANING
284: INTO L_MEANING
285: FROM
286: FND_LOOKUPS
287: WHERE LOOKUP_TYPE = L_LOOKUP_TYPE
288: AND LOOKUP_CODE = SUBSTR(UPPER(P_OPEN_ORDERS_ONLY)
289: ,1
290: ,1);
520: SELECT
521: MEANING
522: INTO L_TEMP
523: FROM
524: FND_LOOKUPS
525: WHERE LOOKUP_CODE = L_LOOKUP_CODE
526: AND LOOKUP_TYPE = L_LOOKUP_TYPE;
527: RETURN (L_TEMP);
528: EXCEPTION