APPS.GR_DISPATCH_HISTORY_PVT dependencies on FND_DOCUMENTS

Line 138: FROM fnd_documents

134:
135: --Cursor used to validate document id
136: CURSOR c_val_document_id IS
137: SELECT 1
138: FROM fnd_documents
139: WHERE document_id = p_document_id;
140:
141: --Cursor used to see if document,version is already in the system
142: CURSOR c_check_document_edr IS

Line 151: FROM fnd_documents_vl

147: order by version_label desc;
148:
149: CURSOR c_check_document_fnd IS
150: SELECT document_id
151: FROM fnd_documents_vl
152: WHERE file_name = p_document_name;
153:
154: --Cursor used to see if document is already in the system
155: CURSOR c_get_doc_id IS

Line 339: --If document does not exist in fnd documents then we need to upload it.

335: ELSE
336: l_doc_found := TRUE;
337: END IF;
338: ELSIF c_check_document_edr%NOTFOUND THEN
339: --If document does not exist in fnd documents then we need to upload it.
340: OPEN c_check_document_fnd;
341: FETCH c_check_document_fnd INTO l_document_id;
342:
343: IF c_check_document_fnd%NOTFOUND THEN