APPS.OE_AUDIT_HISTORY_PVT dependencies on OE_LOOKUPS

Line 157: FROM OE_LOOKUPS

153: IF attribute_value in ('Y','N','P') THEN
154: BEGIN
155: SELECT meaning
156: INTO l_attribute_display_value
157: FROM OE_LOOKUPS
158: WHERE LOOKUP_TYPE = 'CALCULATE_PRICE_FLAG'
159: AND LOOKUP_CODE = attribute_value;
160: END;
161: ELSE

Line 195: FROM OE_LOOKUPS

191: IF attribute_value in ('Y','N') THEN
192: BEGIN
193: SELECT MEANING
194: INTO l_attribute_display_value
195: FROM OE_LOOKUPS
196: WHERE LOOKUP_TYPE = 'YES_NO'
197: AND LOOKUP_CODE = attribute_value;
198: END;
199: else

Line 222: from oe_lookups oel

218: elsif l_attribute_code = 'REASON_CODE' then
219: if (attribute_value is not null) then
220: select meaning
221: into l_attribute_display_value
222: from oe_lookups oel
223: where oel.lookup_type = 'CANCEL_CODE'
224: and oel.lookup_code = attribute_value;
225: else
226: l_attribute_display_value := null;