APPS.OE_AUDIT_HISTORY_PVT dependencies on OE_LOOKUPS

Line 229: FROM OE_LOOKUPS

225: IF attribute_value in ('Y','N','P') THEN
226: BEGIN
227: SELECT meaning
228: INTO l_attribute_display_value
229: FROM OE_LOOKUPS
230: WHERE LOOKUP_TYPE = 'CALCULATE_PRICE_FLAG'
231: AND LOOKUP_CODE = attribute_value;
232: END;
233: ELSE

Line 268: FROM OE_LOOKUPS

264: IF attribute_value in ('Y','N') THEN
265: BEGIN
266: SELECT MEANING
267: INTO l_attribute_display_value
268: FROM OE_LOOKUPS
269: WHERE LOOKUP_TYPE = 'YES_NO'
270: AND LOOKUP_CODE = attribute_value;
271: END;
272: else

Line 295: from oe_lookups oel

291: elsif l_attribute_code = 'REASON_CODE' then
292: if (attribute_value is not null) then
293: select meaning
294: into l_attribute_display_value
295: from oe_lookups oel
296: where oel.lookup_type = 'CANCEL_CODE'
297: and oel.lookup_code = attribute_value;
298: else
299: l_attribute_display_value := null;