APPS.ONT_OEXOEORD_XMLP_PKG dependencies on OE_LOOKUPS

Line 96: OE_LOOKUPS

92: SELECT
93: MEANING
94: INTO L_MEANING
95: FROM
96: OE_LOOKUPS
97: WHERE LOOKUP_TYPE = 'ITEM_DISPLAY_CODE'
98: AND LOOKUP_CODE = SUBSTR(UPPER(P_PRINT_DESCRIPTION)
99: ,1
100: ,1);

Line 113: OE_LOOKUPS

109: SELECT
110: MEANING
111: INTO L_MEANING
112: FROM
113: OE_LOOKUPS
114: WHERE LOOKUP_TYPE = 'YES_NO'
115: AND LOOKUP_CODE = SUBSTR(UPPER(P_OPEN_RETURNS_ONLY)
116: ,1
117: ,1);

Line 303: OE_LOOKUPS

299: ,1
300: ,50)
301: INTO SORT_BY_MEANING
302: FROM
303: OE_LOOKUPS
304: WHERE LOOKUP_TYPE = 'OEXOEORD ORDER BY'
305: AND LOOKUP_CODE = P_ORDER_BY;
306: ELSE
307: SELECT

Line 313: OE_LOOKUPS

309: ,1
310: ,50)
311: INTO SORT_BY_MEANING
312: FROM
313: OE_LOOKUPS
314: WHERE LOOKUP_TYPE = 'OEXOEORD ORDER BY'
315: AND LOOKUP_CODE = 'RETURN_NUMBER';
316: END IF;
317: RETURN (TRUE);