APPS.OKL_DEAL_TERMS_PVT dependencies on OKC_RULE_GROUPS_B

Line 765: okc_rule_groups_b rgp

761: CURSOR c_rule(p_chr_id NUMBER, p_rgd_code VARCHAR2, p_rule_info_cat VARCHAR2) IS
762: SELECT rul.rgp_id,rgp.rgd_code,rul.ID,rul.object1_id1,rul.object1_id2,rul.rule_information1,rul.rule_information2,
763: rul.rule_information3, rul.rule_information4
764: FROM okc_rules_b rul,
765: okc_rule_groups_b rgp
766: WHERE rgp.chr_id = p_chr_id
767: AND rgp.dnz_chr_id = p_chr_id
768: AND rgp.rgd_code = p_rgd_code
769: AND rgp.id = rul.rgp_id

Line 928: okc_rule_groups_b rgp

924: rul_larvau.rule_information1 larvau_rule_information1,
925: rul_larvam.rule_information4 larvam_rule_information4
926: FROM okc_rules_b rul_larvau,
927: okc_rules_b rul_larvam,
928: okc_rule_groups_b rgp
929: WHERE rgp.chr_id = p_chr_id
930: AND rgp.dnz_chr_id = p_chr_id
931: AND rgp.rgd_code = 'LARVIN'
932: AND rul_larvau.rgp_id = rgp.id

Line 1027: from okc_rule_groups_b

1023:
1024:
1025: Cursor l_rgp_csr (p_rgp_id in number) IS
1026: SELECT 'Y'
1027: from okc_rule_groups_b
1028: where id = p_rgp_id;
1029:
1030: l_rgp_found VARCHAR2(1) := 'N';
1031: