DBA Data[Home] [Help]

APPS.EDR_ISIGN_CHECKLIST_PVT dependencies on FND_DOCUMENTS_VL

Line 257: document_id in (select document_id from fnd_documents_vl where category_id in

253:
254: Cursor c1 is select count(*) from fnd_attached_documents
255: where ENTITY_NAME='EDR_FILES_B' and
256: pk1_value=p_file_id and
257: document_id in (select document_id from fnd_documents_vl where category_id in
258: (select category_id
259: from fnd_document_categories_vl
260: where name = 'EDR_ISIGN_ADDL_FILES'));
261: l_count number;

Line 374: document_id in (select document_id from fnd_documents_vl where category_id in

370: l_attach_document_id number;
371: Cursor c1 is select ATTACHED_DOCUMENT_ID from fnd_attached_documents
372: where ENTITY_NAME='EDR_FILES_B' and
373: pk1_value=p_file_id and
374: document_id in (select document_id from fnd_documents_vl where category_id in
375: (select category_id
376: from fnd_document_categories_vl
377: where name = 'EDR_ISIGN_ADDL_FILES'));
378: Begin