APPS.OKC_TERMS_UTIL_GRP dependencies on OKC_TEMPLATE_USAGES_V

Line 1113: FROM okc_template_usages_v tu,

1109: l_return_value VARCHAR2(1) := 'N';
1110:
1111: CURSOR find_tmpl_crs IS
1112: SELECT 'Y'
1113: FROM okc_template_usages_v tu,
1114: okc_terms_templates_all t
1115: WHERE tu.document_type = p_doc_type AND tu.document_id = p_doc_id
1116: AND t.template_id = tu.template_id AND t.status_code = 'APPROVED'
1117: AND nvl(t.end_date,sysdate+1) <= sysdate;

Line 1423: FROM okc_template_usages_v tu, okc_terms_templates_all t

1419: l_return_value VARCHAR2(100) := G_NO_ARTICLE_AMENDED;
1420:
1421: CURSOR find_tmpl_crs IS
1422: SELECT t.template_id, t.template_name
1423: FROM okc_template_usages_v tu, okc_terms_templates_all t
1424: WHERE tu.document_type = p_doc_type AND tu.document_id = p_doc_id
1425: AND t.template_id = tu.template_id;
1426:
1427: BEGIN

Line 2793: FROM okc_template_usages_v tu, okc_terms_templates_all t

2789: SELECT t.template_id,
2790: t.template_name,
2791: t.instruction_text ,
2792: t.description
2793: FROM okc_template_usages_v tu, okc_terms_templates_all t
2794: WHERE tu.document_type = p_doc_type AND tu.document_id = p_doc_id
2795: AND t.template_id = tu.template_id;
2796:
2797: BEGIN