955:
956: CURSOR chr_csr (p_chr_id IN NUMBER) IS
957: SELECT 'Y'
958: FROM okc_k_headers_b chr,
959: okc_statuses_b sts
960: WHERE chr.id = p_chr_id
961: AND sts.code = chr.sts_code
962: AND sts.ste_code IN ('SIGNED', 'ENTERED');
963:
965: p_line_id IN NUMBER) IS
966: SELECT line.id asset_id
967: FROM okc_k_lines_b line,
968: okc_line_styles_b style,
969: okc_statuses_b sts
970: WHERE line.lse_id = style.id
971: AND style.lty_code = 'FREE_FORM1'
972: AND line.dnz_chr_id = p_chr_id
973: AND line.id = nvl(p_line_id,line.id)