[Home] [Help]
APPS.ENG_CHANGE_BES_UTIL dependencies on ENG_CHANGE_ORDER_TYPES
Line 50: ENG_CHANGE_ORDER_TYPES ChangeCategory
46: CURSOR c_base_cm_code(p_change_id NUMBER)
47: IS
48: SELECT ChangeCategory.BASE_CHANGE_MGMT_TYPE_CODE
49: FROM ENG_ENGINEERING_CHANGES EngineeringChangeEO,
50: ENG_CHANGE_ORDER_TYPES ChangeCategory
51: WHERE ChangeCategory.type_classification = 'CATEGORY'
52: AND ChangeCategory.change_mgmt_type_code = EngineeringChangeEO.change_mgmt_type_code
53: AND EngineeringChangeEO.change_id = p_change_id ;
54: