253: SELECT
254: MEANING
255: INTO L_MEANING
256: FROM
257: OE_LOOKUPS
258: WHERE LOOKUP_TYPE = L_LOOKUP_TYPE
259: AND LOOKUP_CODE = L_LOOKUP_CODE;
260: RP_ORDER_CATEGORY := L_MEANING;
261: EXCEPTION
272: SELECT
273: MEANING
274: INTO L_MEANING
275: FROM
276: OE_LOOKUPS
277: WHERE LOOKUP_TYPE = L_LOOKUP_TYPE
278: AND LOOKUP_CODE = L_LOOKUP_CODE;
279: RP_LINE_CATEGORY := L_MEANING;
280: EXCEPTION
479: SELECT
480: MEANING
481: INTO L_SORT_BY
482: FROM
483: OE_LOOKUPS
484: WHERE LOOKUP_CODE = L_LOOKUP_CODE
485: AND LOOKUP_TYPE = L_LOOKUP_TYPE;
486: RETURN (L_SORT_BY);
487: EXCEPTION