APPS.OKC_RENEW_PVT dependencies on OKC_RULES_B

Line 47: FROM okc_rules_b rul,okc_rule_groups_b rgp

43:
44:
45: CURSOR cur_rules(p_chr_id number) is
46: SELECT nvl(rgp.cle_id,rgp.chr_id) comp_id ,nvl(rul.rule_information1,g_def_cle_ren) rule_type
47: FROM okc_rules_b rul,okc_rule_groups_b rgp
48: WHERE rgp.dnz_chr_id = p_chr_id
49: and rgp.id=rul.rgp_id
50: -- and rgp.rgd_code='RENEW'
51: and rul.rule_information_category='LRT' order by rgp.cle_id;

Line 2439: FROM okc_rules_b rul,okc_rule_groups_b rgp

2435:
2436: CURSOR cur_rules(p_chr_id number) is
2437: SELECT nvl(rul.rule_information1,OKC_API.G_MISS_CHAR) renew_type,
2438: nvl(rul.rule_information2,OKC_API.G_MISS_CHAR) contact
2439: FROM okc_rules_b rul,okc_rule_groups_b rgp
2440: WHERE rgp.dnz_chr_id = p_chr_id
2441: and rgp.id=rul.rgp_id
2442: --and rgp.rgd_code='RENEW'
2443: and rul.rule_information_category='REN' ;

Line 3009: FROM okc_rules_b rul,

3005: CURSOR cur_rules(p_chr_id number) is
3006: SELECT nvl(rul.rule_information1, OKC_API.G_MISS_CHAR) renew_type,
3007: fnd_date.Canonical_To_Date(rul.rule_information3) ultimate_end_date
3008: --To_Date(rul.rule_information3, 'YYYY/MM/DD') ultimate_end_date
3009: FROM okc_rules_b rul,
3010: okc_rule_groups_b rgp
3011: WHERE rgp.dnz_chr_id = p_chr_id
3012: and rgp.id = rul.rgp_id
3013: -- and rgp.rgd_code = 'RENEW'