APPS.OKL_PA_DATA_INTEGRITY dependencies on OKC_RULES_B

Line 13: FROM okc_rules_b rules

9: FUNCTION validate_total_residual(p_chr_id okc_k_headers_b.id%TYPE) RETURN VARCHAR2 IS
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'

Line 41: FROM okc_rules_b rules

37: -- this function ensures that each residual share percent defined against the party in the Terms and Conditions page is a positive number
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'