APPS.OZF_PRE_PROCESS_PVT dependencies on OE_TRANSACTION_TYPES_VL

Line 2206: FROM oe_transaction_types_vl

2202:
2203: CURSOR get_order_type_id(pc_date_ordered IN DATE
2204: ,pc_order_type IN VARCHAR2) IS
2205: SELECT transaction_type_id
2206: FROM oe_transaction_types_vl
2207: WHERE transaction_type_code = 'ORDER'
2208: AND TO_DATE(TO_CHAR(pc_date_ordered, 'MM/DD/YYYY'), 'MM/DD/YYYY')
2209: BETWEEN start_date_active AND NVL(end_date_active, SYSDATE)
2210: AND name = pc_order_type;

Line 2215: FROM oe_transaction_types_vl

2211:
2212: CURSOR chk_order_type (pc_order_type IN VARCHAR2
2213: ,pc_order_type_id IN NUMBER) IS
2214: SELECT 'X'
2215: FROM oe_transaction_types_vl
2216: WHERE transaction_type_id = pc_order_type_id
2217: UNION ALL
2218: SELECT 'X'
2219: FROM oe_transaction_types_vl

Line 2219: FROM oe_transaction_types_vl

2215: FROM oe_transaction_types_vl
2216: WHERE transaction_type_id = pc_order_type_id
2217: UNION ALL
2218: SELECT 'X'
2219: FROM oe_transaction_types_vl
2220: WHERE name = pc_order_type ;
2221:
2222: CURSOR get_functional_currency IS
2223: SELECT gs.currency_code