APPS.OKC_TERMS_UTIL_PVT dependencies on OKC_TEMPLATE_USAGES_V

Line 258: SELECT '!' FROM okc_template_usages_v

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

Line 4818: okc_template_usages_v otuv,

4814: SELECT
4815: xdb.template_code
4816: FROM
4817: okc_terms_templates_all otta,
4818: okc_template_usages_v otuv,
4819: xdo_templates_b xdb
4820: WHERE otuv.document_id = p_doc_id
4821: AND otuv.document_type = p_doc_type
4822: AND otuv.template_id = otta.template_id