APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 2601: FROM ahl_unit_config_headers uc,

2597: -- bug fix 4077103 -yazhou
2598: -- To check the current status of the Unit
2599: CURSOR c_uc_status (p_instance_id IN NUMBER) IS
2600: SELECT name, AHL_UTIL_UC_PKG.GET_UC_STATUS_CODE(UNIT_CONFIG_HEADER_ID) uc_status
2601: FROM ahl_unit_config_headers uc,
2602: csi_item_instances csis
2603: WHERE uc.csi_item_instance_id=csis.instance_id
2604: AND (uc.active_end_date IS NULL OR uc.active_end_date > SYSDATE)
2605: AND csis.instance_id = p_instance_id;