[Home] [Help]
25484:
25485: -- 11510 get chr start date for effective date for copy_doc
25486: CURSOR c_art_eff_date (p_doc_type VARCHAR2,p_doc_id NUMBER) IS
25487: SELECT article_effective_date
25488: FROM okc_template_usages_v
25489: WHERE document_type=p_doc_type AND document_id=p_doc_id;
25490: ---------------------------------------------------
25491: CURSOR GetHdrTrxnInfo IS
25492: SELECT
26253:
26254: -- 11510 get chr start date for effective date for copy_doc
26255: CURSOR c_art_eff_date (p_doc_type VARCHAR2,p_doc_id NUMBER) IS
26256: SELECT article_effective_date
26257: FROM okc_template_usages_v
26258: WHERE document_type=p_doc_type AND document_id=p_doc_id;
26259:
26260:
26261: