APPS.OKL_PA_DATA_INTEGRITY dependencies on OKC_RULE_GROUPS_B

Line 14: ,okc_rule_groups_b rule_group

10: -- rule group VGLRS, rule information categor VGLRSP
11: CURSOR c_get_total_share(cp_chr_id okc_k_headers_b.id%TYPE)IS
12: SELECT NVL(SUM(to_number(rules.rule_information2)),0) total_share
13: FROM okc_rules_b rules
14: ,okc_rule_groups_b rule_group
15: WHERE rule_group.id = rules.rgp_id
16: AND rules.rule_information_category = 'VGLRSP'
17: AND rule_group.rgd_code = 'VGLRS'
18: AND rule_group.dnz_chr_id = cp_chr_id;

Line 42: ,okc_rule_groups_b rule_group

38: FUNCTION validate_residual_positive(p_chr_id okc_k_headers_b.id%TYPE) RETURN VARCHAR2 IS
39: CURSOR c_get_residual_share(cp_chr_id okc_k_headers_b.id%TYPE)IS
40: SELECT rules.rule_information2 share_percent
41: FROM okc_rules_b rules
42: ,okc_rule_groups_b rule_group
43: WHERE rule_group.id = rules.rgp_id
44: AND rules.rule_information_category = 'VGLRSP'
45: AND rule_group.rgd_code = 'VGLRS'
46: AND rule_group.dnz_chr_id = cp_chr_id;