APPS.ENG_VAL_CAT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

Select 'X'
from  ENG_CHANGE_MGMT_TYPES_VL ecmt,
      ENG_ENGINEERING_CHANGES echg,
      ENG_CHANGE_ORDER_TYPES eco
where
      ecmt.CHANGE_MGMT_TYPE_CODE = eco.change_mgmt_type_code
and
      eco.change_order_type_id = echg.change_order_type_id
and
      ecmt.CHANGE_MGMT_TYPE_CODE = p_mgmt_code;

Line: 58

Select 'X'
from  ENG_CHANGE_MGMT_TYPES_VL ecmt,
      ENG_ENGINEERING_CHANGES echg,
      ENG_CHANGE_ORDER_TYPES eco
where
      ecmt.CHANGE_MGMT_TYPE_CODE = eco.change_mgmt_type_code
and
      eco.change_order_type_id = echg.change_order_type_id
and
      echg.STATUS_TYPE <> 6 -- Implemented
and
      echg.STATUS_TYPE <> 5 -- Cancelled
and
      ecmt.CHANGE_MGMT_TYPE_CODE = p_mgmt_code;