APPS.ONT_OEXOEORD_XMLP_PKG dependencies on OE_TRANSACTION_TYPES_TL

Line 161: OE_TRANSACTION_TYPES_TL OEOT

157: SELECT
158: OEOT.NAME
159: INTO L_ORDER_TYPE
160: FROM
161: OE_TRANSACTION_TYPES_TL OEOT
162: WHERE OEOT.TRANSACTION_TYPE_ID = P_RETURN_TYPE
163: AND OEOT.LANGUAGE = USERENV('LANG');
164: ELSE
165: LP_RETURN_TYPE := ' ';

Line 185: OE_TRANSACTION_TYPES_TL OEOT

181: SELECT
182: OEOT.NAME
183: INTO L_LINE_TYPE
184: FROM
185: OE_TRANSACTION_TYPES_TL OEOT
186: WHERE OEOT.TRANSACTION_TYPE_ID = P_RETURN_LINE_TYPE
187: AND OEOT.LANGUAGE = USERENV('LANG');
188: ELSE
189: LP_RETURN_LINE_TYPE := ' ';