APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 4656: FROM ahl_unit_config_headers uc,

4652: -- bug fix 4077103 -yazhou
4653: -- To check the current status of the Unit
4654: CURSOR c_uc_status (p_instance_id IN NUMBER) IS
4655: SELECT name, AHL_UTIL_UC_PKG.GET_UC_STATUS_CODE(UNIT_CONFIG_HEADER_ID) uc_status
4656: FROM ahl_unit_config_headers uc,
4657: csi_item_instances csis
4658: WHERE uc.csi_item_instance_id=csis.instance_id
4659: AND (uc.active_end_date IS NULL OR uc.active_end_date > SYSDATE)
4660: AND csis.instance_id = p_instance_id;

Line 6310: FROM AHL_UNIT_CONFIG_HEADERS UC,

6306: -- MANESING::Component Maintenance Planning Project, 02-Nov-2011, added following cursor
6307: -- Cursor to get any instance from UC table
6308: CURSOR get_any_uc_inst_csr IS
6309: SELECT INST.inventory_item_id, UC.csi_item_instance_id
6310: FROM AHL_UNIT_CONFIG_HEADERS UC,
6311: CSI_ITEM_INSTANCES INST
6312: WHERE UC.unit_config_status_code = 'COMPLETE'
6313: AND NVL(UC.active_end_date, SYSDATE+1) > SYSDATE
6314: AND INST.instance_id = UC.csi_item_instance_id