APPS.OKC_XPRT_INT_GRP dependencies on OKC_TEMPLATE_USAGES

Line 71: FROM okc_template_usages

67: where scn_id = p_scn_id;
68:
69: CURSOR l_get_num_scheme_id(p_doc_type VARCHAR2, p_doc_id NUMBER) IS
70: SELECT doc_numbering_scheme
71: FROM okc_template_usages
72: WHERE document_type = p_document_type
73: AND document_id = p_document_id;
74:
75: TYPE IdList IS TABLE OF okc_sections_b.id%TYPE INDEX BY BINARY_INTEGER;

Line 391: FROM okc_template_usages

387:
388: --cursor added for Bug#5012622
389: CURSOR csr_tmpl_id_on_doc IS
390: SELECT template_id
391: FROM okc_template_usages
392: WHERE document_type = p_document_type
393: AND document_id = p_document_id;
394:
395: --cursor added for Bug#4929199