APPS.OKL_CPY_PDT_RULS_PVT dependencies on OKC_RULES_B

Line 282: from okc_rules_b rul

278: CURSOR chk_rul_csr (p_khr_id IN NUMBER,
279: p_rgp_id IN NUMBER,
280: p_rdf_code IN VARCHAR2) IS
281: select rul.id
282: from okc_rules_b rul
283: where rul.rgp_id = p_rgp_id
284: and rul.dnz_chr_id = p_khr_id
285: and rul.rule_information_category = p_rdf_code;
286:

Line 287: l_rul_id OKC_RULES_B.ID%TYPE default Null;

283: where rul.rgp_id = p_rgp_id
284: and rul.dnz_chr_id = p_khr_id
285: and rul.rule_information_category = p_rdf_code;
286:
287: l_rul_id OKC_RULES_B.ID%TYPE default Null;
288:
289: l_rgpv_rec OKC_RULE_PUB.rgpv_rec_type;
290: l_rgpv_rec_out OKC_RULE_PUB.rgpv_rec_type;
291: l_rulv_rec OKC_RULE_PUB.rulv_rec_type;

Line 485: from okc_rules_b rul

481: CURSOR chk_rul_csr (p_khr_id IN NUMBER,
482: p_rgp_id IN NUMBER,
483: p_rdf_code IN VARCHAR2) IS
484: select rul.id
485: from okc_rules_b rul
486: where rul.rgp_id = p_rgp_id
487: and rul.dnz_chr_id = p_khr_id
488: and rul.rule_information_category = p_rdf_code;
489:

Line 490: l_rul_id OKC_RULES_B.ID%TYPE default Null;

486: where rul.rgp_id = p_rgp_id
487: and rul.dnz_chr_id = p_khr_id
488: and rul.rule_information_category = p_rdf_code;
489:
490: l_rul_id OKC_RULES_B.ID%TYPE default Null;
491:
492: l_rgpv_rec OKC_RULE_PUB.rgpv_rec_type;
493: l_rgpv_rec_out OKC_RULE_PUB.rgpv_rec_type;
494: