DBA Data[Home] [Help]

APPS.OE_BLANKET_UTIL dependencies on OE_TRANSACTION_TYPES_ALL

Line 6533: FROM oe_transaction_types_all

6529: --
6530:
6531: CURSOR c_contract_template_exist (cp_trans_type_id NUMBER) IS
6532: SELECT contract_template_id
6533: FROM oe_transaction_types_all
6534: WHERE transaction_type_id = cp_trans_type_id;
6535:
6536: l_order_type_id NUMBER := NULL;
6537: l_deflt_contract_template_id NUMBER := NULL;

Line 6648: from oe_transaction_types_all

6644: -- Get The Transaciton Phase from the Order Type if any.
6645: Begin
6646: Select /* MOAC_SQL_CHANGE */ DEF_TRANSACTION_PHASE_CODE
6647: INTO p_x_header_rec.transaction_phase_code
6648: from oe_transaction_types_all
6649: where TRANSACTION_TYPE_ID = p_x_header_rec.order_type_id;
6650: Exception
6651: when no_data_found then
6652: null;