APPS.OE_BLANKET_UTIL dependencies on OE_TRANSACTION_TYPES_ALL

Line 6727: FROM oe_transaction_types_all

6723: --
6724:
6725: CURSOR c_contract_template_exist (cp_trans_type_id NUMBER) IS
6726: SELECT contract_template_id
6727: FROM oe_transaction_types_all
6728: WHERE transaction_type_id = cp_trans_type_id;
6729:
6730: l_order_type_id NUMBER := NULL;
6731: l_deflt_contract_template_id NUMBER := NULL;

Line 6842: from oe_transaction_types_all

6838: -- Get The Transaciton Phase from the Order Type if any.
6839: Begin
6840: Select /* MOAC_SQL_CHANGE */ DEF_TRANSACTION_PHASE_CODE
6841: INTO p_x_header_rec.transaction_phase_code
6842: from oe_transaction_types_all
6843: where TRANSACTION_TYPE_ID = p_x_header_rec.order_type_id;
6844: Exception
6845: when no_data_found then
6846: null;