APPS.OKL_DEAL_TERMS_PVT dependencies on OKC_RULE_GROUPS_B

Line 788: okc_rule_groups_b rgp

784: CURSOR c_rule(p_chr_id NUMBER, p_rgd_code VARCHAR2, p_rule_info_cat VARCHAR2) IS
785: SELECT rul.rgp_id,rgp.rgd_code,rul.ID,rul.object1_id1,rul.object1_id2,rul.rule_information1,rul.rule_information2,
786: rul.rule_information3, rul.rule_information4
787: FROM okc_rules_b rul,
788: okc_rule_groups_b rgp
789: WHERE rgp.chr_id = p_chr_id
790: AND rgp.dnz_chr_id = p_chr_id
791: AND rgp.rgd_code = p_rgd_code
792: AND rgp.id = rul.rgp_id

Line 798: l_rgp_id okc_rule_groups_b.ID%TYPE; --Bug#9852347

794: AND rul.rule_information_category = p_rule_info_cat;
795:
796: l_rule c_rule%ROWTYPE;
797: l_empty_rule c_rule%ROWTYPE; --Bug#9852347
798: l_rgp_id okc_rule_groups_b.ID%TYPE; --Bug#9852347
799:
800: CURSOR c_payment_method(p_object1_id1 NUMBER) IS
801: SELECT name
802: FROM okx_receipt_methods_v

Line 1006: okc_rule_groups_b rgp

1002: rul_larvau.rule_information1 larvau_rule_information1,
1003: rul_larvam.rule_information4 larvam_rule_information4
1004: FROM okc_rules_b rul_larvau,
1005: okc_rules_b rul_larvam,
1006: okc_rule_groups_b rgp
1007: WHERE rgp.chr_id = p_chr_id
1008: AND rgp.dnz_chr_id = p_chr_id
1009: AND rgp.rgd_code = 'LARVIN'
1010: AND rul_larvau.rgp_id = rgp.id

Line 1105: from okc_rule_groups_b

1101:
1102:
1103: Cursor l_rgp_csr (p_rgp_id in number) IS
1104: SELECT 'Y'
1105: from okc_rule_groups_b
1106: where id = p_rgp_id;
1107:
1108: l_rgp_found VARCHAR2(1) := 'N';
1109: