APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKC_RULES_V

Line 2031: okc_rules_v rul

2027: RETURN VARCHAR2 IS
2028: CURSOR grp_csr ( cp_khr_id NUMBER ) IS
2029: select RULE_INFORMATION1
2030: from okc_rule_groups_v rgp,
2031: okc_rules_v rul
2032: where rgp.dnz_chr_id = cp_khr_id AND
2033: rgp.chr_id = rgp.dnz_chr_id AND
2034: rgp.id = rul.rgp_id AND
2035: rgp.cle_id IS NULL AND

Line 2039: l_grp okc_rules_v.rule_information1%type:= 'NONE';

2035: rgp.cle_id IS NULL AND
2036: rgp.rgd_code = 'LABILL' AND
2037: rul.rule_information_category = 'LAINVD';
2038:
2039: l_grp okc_rules_v.rule_information1%type:= 'NONE';
2040:
2041: BEGIN
2042:
2043: OPEN grp_csr(p_khr_id);