DBA Data[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: