776: SELECT
777: MEANING
778: INTO L_RETURN_VALUE
779: FROM
780: OE_LOOKUPS
781: WHERE LOOKUP_TYPE = 'OM_YES_NO'
782: AND LOOKUP_CODE = 'NO';
783: ELSE
784: SELECT
784: SELECT
785: MEANING
786: INTO L_RETURN_VALUE
787: FROM
788: OE_LOOKUPS
789: WHERE LOOKUP_TYPE = 'OM_YES_NO'
790: AND LOOKUP_CODE = 'YES';
791: END IF;
792: RETURN L_RETURN_VALUE;
1259: l_meaning VARCHAR2 (80);
1260: BEGIN
1261: SELECT MEANING
1262: INTO l_meaning
1263: FROM OE_LOOKUPS
1264: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY_CODE'
1265: AND LOOKUP_CODE = substr(upper(p_print_description),1,1)
1266: ;
1267: