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: )