APPS.FRM_SECURITY_PKG dependencies on FRM_DOCUMENTS_VL

Line 63: FROM FRM_DOCUMENTS_VL DOC

59: IF UPPER(P_MENU_TYPE) = 'DOCUMENT' THEN
60:
61: SELECT DOC.DIRECTORY_ID
62: INTO VN_DIRECTORY_ID
63: FROM FRM_DOCUMENTS_VL DOC
64: WHERE DOC.DOCUMENT_ID = P_MENU_ID
65: AND ((DOC.END_DATE IS NULL OR DOC.END_DATE > SYSDATE)
66: OR (DOC.DOCUMENT_ID IN (SELECT PUB.DOCUMENT_ID FROM FRM_DOC_PUB_OPTIONS PUB
67: WHERE PUB.DOCUMENT_ID = P_MENU_ID AND PUB.END_DATE > SYSDATE)));

Line 313: FROM FRM_DOCUMENTS_VL DOC

309: IF UPPER(P_MENU_TYPE) = 'DOCUMENT' THEN
310:
311: SELECT DOC.DIRECTORY_ID
312: INTO VN_DIRECTORY_ID
313: FROM FRM_DOCUMENTS_VL DOC
314: WHERE DOC.DOCUMENT_ID = P_MENU_ID
315: AND ((DOC.END_DATE IS NULL OR DOC.END_DATE > SYSDATE)
316: OR (DOC.DOCUMENT_ID IN (SELECT PUB.DOCUMENT_ID FROM FRM_DOC_PUB_OPTIONS PUB
317: WHERE PUB.DOCUMENT_ID = P_MENU_ID AND PUB.END_DATE > SYSDATE)));

Line 597: FROM FRM_DOCUMENTS_VL DOC

593: IF UPPER(P_MENU_TYPE) = 'DOCUMENT' THEN
594:
595: SELECT DOC.DOCUMENT_ID
596: INTO VN_MENU_ID
597: FROM FRM_DOCUMENTS_VL DOC
598: WHERE DOC.DOCUMENT_ID = P_MENU_ID
599: AND ((DOC.END_DATE IS NULL OR DOC.END_DATE > SYSDATE)
600: OR (DOC.DOCUMENT_ID IN (SELECT PUB.DOCUMENT_ID FROM FRM_DOC_PUB_OPTIONS PUB
601: WHERE PUB.DOCUMENT_ID = P_MENU_ID AND PUB.END_DATE > SYSDATE)));