APPS.ONT_OEXOEUBD_XMLP_PKG dependencies on OE_LOOKUPS

Line 28: OE_LOOKUPS

24: SELECT
25: MEANING
26: INTO LP_ORDER_BY_MEAN
27: FROM
28: OE_LOOKUPS
29: WHERE LOOKUP_CODE = UPPER(P_ORDER_BY)
30: AND LOOKUP_TYPE = 'ONT_OEXOEUBD_XMLP_PKG SORT BY';
31: IF (UPPER(P_ORDER_BY) = 'CREATED_BY') THEN
32: LP_ORDER_BY := 'order by 5,2,1';

Line 369: FROM OE_LOOKUPS

365: l_meaning VARCHAR2 (80);
366: BEGIN
367: SELECT MEANING
368: INTO l_meaning
369: FROM OE_LOOKUPS
370: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY_CODE'
371: AND LOOKUP_CODE = substr(upper(p_print_description),1,1)
372: ;
373: