234:
235: CURSOR l_chrv_csr IS
236: SELECT chrv.*, sub.cls_code
237: FROM OKC_K_HEADERS_B chrv,
238: OKC_SUBCLASSES_B sub
239: WHERE chrv.id = p_chr_id
240: AND sub.code = chrv.scs_code;
241: l_chrv_rec l_chrv_csr%ROWTYPE;
242:
566: p_rgd_code IN OKC_RULE_GROUPS_B.rgd_code%TYPE,
567: p_rgp_id IN OKC_RULE_GROUPS_B.id%TYPE,
568: p_chr_id IN OKC_RULE_GROUPS_B.chr_id%TYPE,
569: p_cle_id IN OKC_RULE_GROUPS_B.cle_id%TYPE,
570: p_cls_code IN OKC_SUBCLASSES_B.CLS_CODE%TYPE
571: ) IS
572:
573: CURSOR l_cti_csr IS
574: SELECT 'x'
1001:
1002: CURSOR l_chr_csr IS
1003: SELECT chr.*, sub.cls_code
1004: FROM OKC_K_HEADERS_B chr,
1005: OKC_SUBCLASSES_B sub
1006: WHERE chr.id = p_chr_id
1007: AND sub.code = chr.scs_code;
1008: l_chr_rec l_chr_csr%ROWTYPE;
1009: