APPS.JAI_OM_TAX_PROCESSING_PKG dependencies on OE_ORDER_SOURCES

Line 3774: FROM oe_order_sources

3770: v_api_name CONSTANT VARCHAR2(30) := 'POPULATE_TAX';
3771:
3772: CURSOR get_order_source_type(p_source_document_type_id NUMBER) IS
3773: SELECT name
3774: FROM oe_order_sources
3775: WHERE order_source_id = p_source_document_type_id;
3776:
3777: ---------------------------------
3778: /* Declarations for Copy Order */

Line 4545: FROM oe_order_sources

4541: v_sales_return_days Number;
4542:
4543: CURSOR get_order_source_type(cp_source_document_type_id NUMBER) IS
4544: SELECT name
4545: FROM oe_order_sources
4546: WHERE order_source_id = cp_source_document_type_id;
4547:
4548: V_Order_Source_Type OE_ORDER_SOURCES.NAME%TYPE;
4549:

Line 4548: V_Order_Source_Type OE_ORDER_SOURCES.NAME%TYPE;

4544: SELECT name
4545: FROM oe_order_sources
4546: WHERE order_source_id = cp_source_document_type_id;
4547:
4548: V_Order_Source_Type OE_ORDER_SOURCES.NAME%TYPE;
4549:
4550: cursor c_rma_line_dtls(cp_rma_line_id in number) is
4551: select delivery_detail_id,
4552: nvl(allow_excise_credit_flag, 'N') allow_excise_credit_flag,