442: CURSOR c_get_attch_doc_details IS
443: SELECT
444: a.entity_name
445: FROM fnd_attached_documents a,
446: fnd_documents d
447: WHERE
448: d.category_id IN
449: (SELECT category_id
450: FROM FND_DOCUMENT_CATEGORIES
490:
491: /* Used to get the Latest Details of a Regulatory Item Document */
492: CURSOR c_latest_document IS
493: SELECT *
494: FROM fnd_documents_vl
495: WHERE DOC_ATTRIBUTE1 = l_item_code
496: and DOC_ATTRIBUTE2 = l_territory_details.DOCUMENT_CODE
497: and DOC_ATTRIBUTE3 = l_territory_details.LANGUAGE
498: and DOC_ATTRIBUTE4 = l_territory_details.DISCLOSURE_CODE
768: /* ------------------ CURSORS ---------------------- */
769: /* Used to get the document information for all Regulatory document categories */
770: CURSOR c_get_doc_info IS
771: SELECT *
772: FROM fnd_documents_vl a
773: WHERE a.creation_date = (SELECT max(b.creation_date) FROM fnd_documents_vl b
774: WHERE a.doc_attribute1 = b.doc_attribute1
775: AND a.doc_attribute3 = b.doc_attribute3
776: AND a.doc_attribute5 = l_orgn_code
769: /* Used to get the document information for all Regulatory document categories */
770: CURSOR c_get_doc_info IS
771: SELECT *
772: FROM fnd_documents_vl a
773: WHERE a.creation_date = (SELECT max(b.creation_date) FROM fnd_documents_vl b
774: WHERE a.doc_attribute1 = b.doc_attribute1
775: AND a.doc_attribute3 = b.doc_attribute3
776: AND a.doc_attribute5 = l_orgn_code
777: AND (UPPER(b.DOC_ATTRIBUTE_CATEGORY) like l_bind_var_msds