APPS.AHL_PRD_WO_PUB dependencies on AHL_UTIL_UC_PKG

Line 659: AND AHL_UTIL_UC_PKG.GET_UC_HEADER_ID(VTS.INSTANCE_ID) = PCA.UNIT_ITEM_ID

655: AHL_DOCUMENT_ASSOS_V DOC
656: WHERE
657: WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID
658: AND WO.WORKORDER_ID = p_WorkorderId
659: AND AHL_UTIL_UC_PKG.GET_UC_HEADER_ID(VTS.INSTANCE_ID) = PCA.UNIT_ITEM_ID
660: and pca.pc_node_id = doc.aso_object_id
661: AND DOC.ASO_OBJECT_TYPE_CODE = 'PC';
662:
663: BEGIN