APPS.OKL_CONS_BILL dependencies on OKC_RULES_V

Line 285: okc_rules_v rul

281: RETURN VARCHAR2 IS
282: CURSOR grp_csr ( cp_khr_id NUMBER ) IS
283: select RULE_INFORMATION1
284: from okc_rule_groups_v rgp,
285: okc_rules_v rul
286: where rgp.dnz_chr_id = cp_khr_id AND
287: rgp.chr_id = rgp.dnz_chr_id AND
288: rgp.id = rul.rgp_id AND
289: rgp.cle_id IS NULL AND

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

289: rgp.cle_id IS NULL AND
290: rgp.rgd_code = 'LABILL' AND
291: rul.rule_information_category = 'LAINVD';
292:
293: l_grp okc_rules_v.rule_information1%type:= 'NONE';
294:
295: BEGIN
296:
297: OPEN grp_csr(p_khr_id);