APPS.OKC_TERMS_UTIL_PVT dependencies on OKC_TEMPLATE_USAGES_V

Line 255: SELECT '!' FROM okc_template_usages_v

251: SELECT '!' FROM okc_terms_templates
252: WHERE parent_template_id = p_doc_id;
253:
254: CURSOR tmpl_usd_crs IS
255: SELECT '!' FROM okc_template_usages_v
256: WHERE TEMPLATE_ID = p_doc_id AND ROWNUM=1;
257:
258: CURSOR tt_csr IS
259: SELECT TEMPLATE_ID, object_version_number,template_model_id

Line 4769: okc_template_usages_v otuv,

4765: SELECT
4766: xdb.template_code
4767: FROM
4768: okc_terms_templates_all otta,
4769: okc_template_usages_v otuv,
4770: xdo_templates_b xdb
4771: WHERE otuv.document_id = p_doc_id
4772: AND otuv.document_type = p_doc_type
4773: AND otuv.template_id = otta.template_id