APPS.OKC_K_ARTICLE_PUB dependencies on OKC_TEMPLATE_USAGES_V

Line 604: SELECT TEMPLATE_ID FROM okc_template_usages_v

600: SELECT ID FROM OKC_SECTIONS_B
601: WHERE document_type = p_doc_type AND document_id = p_doc_id
602: AND scn_code = G_UNASSIGNED_SECTION_CODE;
603: CURSOR get_doc_usage_crs IS
604: SELECT TEMPLATE_ID FROM okc_template_usages_v
605: WHERE document_type = p_doc_type AND document_id = p_doc_id ;
606: CURSOR get_apps_upg_tmpl_id_crs IS
607: SELECT TEMPLATE_ID FROM okc_terms_templates_all
608: WHERE template_name = l_tmpl_name and nvl(org_id,-99)=nvl(l_org_id,-99);