APPS.OKC_RENEW_PUB dependencies on OKC_RULES_B

Line 359: FROM okc_rules_b rul,okc_rule_groups_b rgp

355:
356: CURSOR cur_rules(p_chr_id number) is
357: SELECT nvl(rul.rule_information1,OKC_API.G_MISS_CHAR) renew_type,
358: nvl(rul.rule_information2,OKC_API.G_MISS_CHAR) contact
359: FROM okc_rules_b rul,okc_rule_groups_b rgp
360: WHERE rgp.dnz_chr_id = p_chr_id
361: and rgp.id=rul.rgp_id
362: --and rgp.rgd_code='RENEW'
363: and rul.rule_information_category='REN' ;