6130: AND G_COPY_HISTORY_YN = 'Y';
6131: ---------------------------------------------------
6132: CURSOR c_cnhv IS
6133: SELECT id
6134: FROM okc_condition_headers_b
6135: WHERE dnz_chr_id = p_chr_id
6136: AND g_copy_history_yn = 'N'
6137: UNION ALL
6138: SELECT id
6135: WHERE dnz_chr_id = p_chr_id
6136: AND g_copy_history_yn = 'N'
6137: UNION ALL
6138: SELECT id
6139: FROM okc_condition_headers_bH
6140: WHERE dnz_chr_id = p_chr_id
6141: AND major_version = G_FROM_VERSION_NUMBER
6142: AND G_COPY_HISTORY_YN = 'Y';
6143: ---------------------------------------------------
9985:
9986: CURSOR c_cnh(p_id IN NUMBER) IS
9987: SELECT dnz_chr_id,
9988: template_yn
9989: FROM okc_condition_headers_b
9990: WHERE id = p_id;
9991:
9992: CURSOR c_isev_rel(p_id IN NUMBER) IS
9993: SELECT START_PARENT_DATE,