APPS.AHL_PRD_WO_PUB dependencies on AHL_UTIL_UC_PKG

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

639: ahl_reference_doc_v DOC, AHL_DOC_REVISIONS_B REV
640: WHERE
641: WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID
642: AND WO.WORKORDER_ID = p_WorkorderId
643: AND AHL_UTIL_UC_PKG.GET_UC_HEADER_ID(VTS.INSTANCE_ID) = PCA.UNIT_ITEM_ID
644: AND PCA.PC_NODE_ID = DOC.ASO_OBJECT_ID
645: AND DOC.ASO_OBJECT_TYPE_CODE = 'PC'
646: AND REV.DOCUMENT_ID(+) = DOC.DOCUMENT_ID
647: AND TRUNC(NVL(REV.OBSOLETE_DATE, SYSDATE + 1)) > TRUNC(SYSDATE);