980:
981: --cursor to find out chr id required to flip status at edit point
982: CURSOR chr_id_crs (p_rul_id IN NUMBER) is
983: SELECT DNZ_CHR_ID
984: FROM OKC_RULES_B
985: WHERE ID = P_RUL_ID;
986:
987: l_dnz_chr_id OKC_RULES_B.dnz_chr_id%TYPE;
988:
983: SELECT DNZ_CHR_ID
984: FROM OKC_RULES_B
985: WHERE ID = P_RUL_ID;
986:
987: l_dnz_chr_id OKC_RULES_B.dnz_chr_id%TYPE;
988:
989: -- Start 14-Sep-2005 Manu
990: CURSOR lc_category_csr (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE) IS
991: SELECT scs_code