APPS.AHL_FMP_MR_REVISION_PVT dependencies on AHL_DOC_REVISIONS_VL

Line 295: FROM AHL_DOC_REVISIONS_VL

291: AND A.ASO_OBJECT_ID=p_source_mr_header_id
292: and A.doc_title_asso_id=B.doc_title_asso_id
293: AND B.LANGUAGE=USERENV('LANG')
294: AND A.ASO_OBJECT_ID NOT IN (SELECT DOCUMENT_ID
295: FROM AHL_DOC_REVISIONS_VL
296: WHERE DOCUMENT_ID=A.ASO_OBJECT_ID
297: AND NVL(REVISION_STATUS_CODE,'CURRENT')='OBSOLETE');
298:
299: l_doc_title_asso_id NUMBER:=0;