APPS.AHL_PRD_WO_PUB dependencies on AHL_PC_ASSOCIATIONS

Line 638: AHL_WORKORDERS WO, AHL_PC_ASSOCIATIONS PCA, AHL_VISIT_TASKS_B VTS,

634: SELECT
635: DOC.DOCUMENT_NO, DOC.DOCUMENT_TITLE, DOC.ASO_OBJECT_TYPE_DESC, DOC.REVISION_NO,
636: DOC.CHAPTER, DOC.SECTION, DOC.SUBJECT, DOC.PAGE, DOC.FIGURE, DOC.NOTE
637: FROM
638: AHL_WORKORDERS WO, AHL_PC_ASSOCIATIONS PCA, AHL_VISIT_TASKS_B VTS,
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