APPS.OKC_UTIL dependencies on OKC_TEMPLATE_USAGES_V

Line 3307: SELECT TEMPLATE_ID FROM okc_template_usages_v

3303: CURSOR start_date_crs IS
3304: SELECT start_date, authoring_org_id
3305: FROM OKC_K_HEADERS_B WHERE id=p_chr_id;
3306: CURSOR get_doc_usage_crs IS
3307: SELECT TEMPLATE_ID FROM okc_template_usages_v
3308: WHERE document_type = x_doc_type AND document_id = x_doc_id ;
3309: CURSOR get_apps_upg_tmpl_id_crs IS
3310: SELECT TEMPLATE_ID FROM okc_terms_templates_all
3311: WHERE template_name = l_tmpl_name and org_id=l_org_id;