APPS.ENG_CHANGE_BES_UTIL dependencies on ENG_ENGINEERING_CHANGES

Line 25: FROM eng_engineering_changes ec

21: CURSOR c_cm_code(c_change_id NUMBER)
22: IS
23: -- Select cm category code
24: SELECT ec.change_mgmt_type_code
25: FROM eng_engineering_changes ec
26: WHERE ec.change_id = p_change_id ;
27:
28: BEGIN
29: FOR l_rec IN c_cm_code (c_change_id => p_change_id)

Line 49: FROM ENG_ENGINEERING_CHANGES EngineeringChangeEO,

45:
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 ;