APPS.FND_GFM dependencies on FND_DOCUMENTS_VL

Line 576: FROM FND_DOCUMENTS_VL FDVL

572: CURSOR c_orph_attch_lob IS
573: SELECT file_id
574: FROM FND_LOBS FL
575: WHERE NOT EXISTS (SELECT '1'
576: FROM FND_DOCUMENTS_VL FDVL
577: WHERE FDVL.MEDIA_ID = FL.FILE_ID
578: AND FDVL.DATATYPE_ID = 6)
579: AND PROGRAM_NAME = 'FNDATTCH'
580: AND EXPIRATION_DATE IS NULL;

Line 608: from fnd_documents_vl

604: fetch c_orph_attch_lob into l_file_id;
605: EXIT WHEN c_orph_attch_lob%NOTFOUND;
606:
607: select count(*) into l_doc_cnt
608: from fnd_documents_vl
609: where datatype_id = 6
610: and media_id = l_file_id;
611:
612: if (l_doc_cnt = 0) then -- set expiration date