873: WHERE DOCUMENT_TYPE = p_doc_type
874: AND DOCUMENT_ID = p_doc_id
875: UNION ALL
876: SELECT G_TRUE 877: FROM dual 878: WHERE NOT EXISTS (SELECT 'Y' FROM OKC_TEMPLATE_USAGES
879: WHERE DOCUMENT_TYPE = p_doc_type
880: AND DOCUMENT_ID = p_doc_id
881: )