419: SELECT
420: MEANING
421: INTO ORDER_BY
422: FROM
423: OE_LOOKUPS
424: WHERE LOOKUP_TYPE = L_LOOKUP_TYPE
425: AND LOOKUP_CODE = L_LOOKUP_CODE;
426: RP_ORDER_BY := ORDER_BY;
427: EXCEPTION
474: SELECT
475: MEANING
476: INTO ITEM_DISPLAY_MEANING
477: FROM
478: OE_LOOKUPS
479: WHERE LOOKUP_TYPE = L_LOOKUP_TYPE
480: AND LOOKUP_CODE = L_LOOKUP_CODE;
481: RP_FLEX_OR_DESC := ITEM_DISPLAY_MEANING;
482: END;
715: SELECT
716: MEANING
717: INTO L_MEANING
718: FROM
719: OE_LOOKUPS
720: WHERE LOOKUP_TYPE = L_LOOKUP_TYPE
721: AND LOOKUP_CODE = L_LOOKUP_CODE;
722: RETURN (L_MEANING);
723: EXCEPTION
737: SELECT
738: MEANING
739: INTO L_MEANING
740: FROM
741: OE_LOOKUPS
742: WHERE LOOKUP_TYPE = L_LOOKUP_TYPE
743: AND LOOKUP_CODE = L_LOOKUP_CODE;
744: RETURN (L_MEANING);
745: EXCEPTION