APPS.OKC_TERMS_UTIL_GRP dependencies on OKC_TEMPLATE_USAGES_V

Line 1009: FROM okc_template_usages_v tu,

1005: l_return_value VARCHAR2(1) := 'N';
1006:
1007: CURSOR find_tmpl_crs IS
1008: SELECT 'Y'
1009: FROM okc_template_usages_v tu,
1010: okc_terms_templates_all t
1011: WHERE tu.document_type = p_doc_type AND tu.document_id = p_doc_id
1012: AND t.template_id = tu.template_id AND t.status_code = 'APPROVED'
1013: AND nvl(t.end_date,sysdate+1) <= sysdate;

Line 1319: FROM okc_template_usages_v tu, okc_terms_templates_all t

1315: l_return_value VARCHAR2(100) := G_NO_ARTICLE_AMENDED;
1316:
1317: CURSOR find_tmpl_crs IS
1318: SELECT t.template_id, t.template_name
1319: FROM okc_template_usages_v tu, okc_terms_templates_all t
1320: WHERE tu.document_type = p_doc_type AND tu.document_id = p_doc_id
1321: AND t.template_id = tu.template_id;
1322:
1323: BEGIN

Line 2683: FROM okc_template_usages_v tu, okc_terms_templates_all t

2679: SELECT t.template_id,
2680: t.template_name,
2681: t.instruction_text ,
2682: t.description
2683: FROM okc_template_usages_v tu, okc_terms_templates_all t
2684: WHERE tu.document_type = p_doc_type AND tu.document_id = p_doc_id
2685: AND t.template_id = tu.template_id;
2686:
2687: BEGIN