APPS.OKC_AR_INT_PUB dependencies on OKC_RULE_GROUPS_B

Line 43: FROM okc_rule_groups_b rgb,

39: -- rule at line level
40: CURSOR csr_line_rules(p_rule_code IN VARCHAR2, p_cle_id IN NUMBER, p_chr_id IN NUMBER) IS
41: SELECT rule_information1, rule_information2,
42: rule_information3, rule_information4
43: FROM okc_rule_groups_b rgb,
44: okc_rules_b rul
45: WHERE rgb.id = rul.rgp_id
46: AND rgb.rgd_code = 'REVENUE_CONTINGENCY_RULES'
47: AND rgb.dnz_chr_id = p_chr_id

Line 55: FROM okc_rule_groups_b rgb,

51: -- rule at header level
52: CURSOR csr_header_rules(p_rule_code IN VARCHAR2, p_chr_id IN NUMBER) IS
53: SELECT rule_information1, rule_information2,
54: rule_information3, rule_information4
55: FROM okc_rule_groups_b rgb,
56: okc_rules_b rul
57: WHERE rgb.id = rul.rgp_id
58: AND rgb.rgd_code = 'REVENUE_CONTINGENCY_RULES'
59: AND rgb.chr_id = p_chr_id