DBA Data[Home] [Help]

APPS.AHL_DI_FILEUPLOAD_PVT dependencies on AHL_DOC_FILE_ASSOC_V

Line 56: select FUPV.FILE_ID , FUPV.FILE_NAME from AHL_DOC_FILE_ASSOC_V FUPV, FND_LOBS FLOB

52: FROM dual;
53:
54:
55: CURSOR c_does_attach_exist (l_revid IN VARCHAR2) IS
56: select FUPV.FILE_ID , FUPV.FILE_NAME from AHL_DOC_FILE_ASSOC_V FUPV, FND_LOBS FLOB
57: where FUPV.REVISION_ID = l_revid
58: and FUPV.FILE_ID = FLOB.FILE_ID;
59:
60: l_attach_doc c_does_attach_exist%ROWTYPE;

Line 347: select FUPV.ASSOCIATION_ID from AHL_DOC_FILE_ASSOC_V FUPV , FND_LOBS FLOB

343: l_assoc_id NUMBER;
344: l_security_group_id NUMBER;
345:
346: CURSOR c_get_association_id (l_revid IN VARCHAR2) IS
347: select FUPV.ASSOCIATION_ID from AHL_DOC_FILE_ASSOC_V FUPV , FND_LOBS FLOB
348: where FUPV.REVISION_ID = l_revid
349: and FUPV.FILE_ID = FLOB.FILE_ID;
350:
351: BEGIN