DBA Data[Home] [Help]

APPS.OKL_DEAL_TERMS_PVT dependencies on OKC_RULES_B

Line 764: FROM okc_rules_b rul,

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

Line 926: FROM okc_rules_b rul_larvau,

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

Line 927: okc_rules_b rul_larvam,

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