DBA Data[Home] [Help]

APPS.OKL_DEAL_TERMS_PVT dependencies on OKC_RULES_B

Line 787: FROM okc_rules_b rul,

783:
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

Line 1004: FROM okc_rules_b rul_larvau,

1000: rul_larvam.id rul_larvam_id,
1001: rul_larvam.rule_information_category larvam_rule_info_cat,
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

Line 1005: okc_rules_b rul_larvam,

1001: rul_larvam.rule_information_category larvam_rule_info_cat,
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'