DBA Data[Home] [Help]

APPS.OKL_EVERGREEN_BILLING_PVT dependencies on OKC_RULE_GROUPS_B

Line 196: okc_rule_groups_b b,

192: FROM okl_strm_elements ste,
193: (
194: SELECT stm.id, to_number(rule_information6) amt
195: FROM okc_rules_b a,
196: okc_rule_groups_b b,
197: okl_streams stm,
198: okl_strm_type_v sty
199: WHERE a.dnz_chr_id = p_khr_id
200: AND a.rgp_id = b.id

Line 263: Okc_rule_groups_B rgp

259: --changed for rules migration
260: CURSOR c_bill_freq_csr( p_khr_id NUMBER ) IS
261: SELECT object1_id1
262: FROM OKC_RULES_B rul,
263: Okc_rule_groups_B rgp
264: WHERE rul.rgp_id = rgp.id AND
265: rgp.rgd_code = 'LALEVL' AND
266: rgp.chr_id IS NULL AND
267: rul.rule_information_category = 'LASLL' AND