APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_TEMPLATE_USAGES_V

Line 6115: FROM okc_template_usages_v

6111:
6112: -- 11510 get chr start date for effective date for copy_doc
6113: CURSOR c_art_eff_date (p_doc_type VARCHAR2,p_doc_id NUMBER) IS
6114: SELECT article_effective_date
6115: FROM okc_template_usages_v
6116: WHERE document_type=p_doc_type AND document_id=p_doc_id;
6117: ---------------------------------------------------
6118: CURSOR c_cplv IS
6119: SELECT id

Line 10433: FROM okc_template_usages_v

10429:
10430: -- 11510 get chr start date for effective date for copy_doc
10431: CURSOR c_art_eff_date (p_doc_type VARCHAR2,p_doc_id NUMBER) IS
10432: SELECT article_effective_date
10433: FROM okc_template_usages_v
10434: WHERE document_type=p_doc_type AND document_id=p_doc_id;
10435:
10436: --cursor to fetch id of line with lseid =20 -Bug:3668722
10437: CURSOR c_lines(p NUMBER) IS