APPS.OKC_UTIL dependencies on OKC_TEMPLATE_USAGES_V

Line 3319: SELECT TEMPLATE_ID FROM okc_template_usages_v

3315: CURSOR start_date_crs IS
3316: SELECT start_date, authoring_org_id
3317: FROM OKC_K_HEADERS_B WHERE id=p_chr_id;
3318: CURSOR get_doc_usage_crs IS
3319: SELECT TEMPLATE_ID FROM okc_template_usages_v
3320: WHERE document_type = x_doc_type AND document_id = x_doc_id ;
3321: CURSOR get_apps_upg_tmpl_id_crs IS
3322: SELECT TEMPLATE_ID FROM okc_terms_templates_all
3323: WHERE template_name = l_tmpl_name and org_id=l_org_id;