APPS.OKC_NUMBER_SCHEME_GRP dependencies on OKC_TEMPLATE_USAGES_V

Line 1338: SELECT 'N' from OKC_TEMPLATE_USAGES_V

1334: CURSOR used_in_tmpl_crs IS
1335: SELECT 'N' from OKC_TERMS_TEMPLATES_ALL
1336: WHERE TMPL_NUMBERING_SCHEME=p_num_scheme_id;
1337: CURSOR used_in_doc_crs IS -- it's required index on DOC_NUMBERING_SCHEME column
1338: SELECT 'N' from OKC_TEMPLATE_USAGES_V
1339: WHERE DOC_NUMBERING_SCHEME=p_num_scheme_id;
1340: l_ret VARCHAR2(1) := 'Y';
1341: BEGIN
1342: OPEN used_in_tmpl_crs;