DBA Data[Home] [Help]

APPS.OKL_EVERGREEN_BILLING_PVT dependencies on OKC_RULES_B

Line 195: FROM okc_rules_b a,

191: SELECT ste.amount
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

Line 262: FROM OKC_RULES_B rul,

258: ------------------------------------------------------------
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

Line 460: l_bill_freq OKC_RULES_B.object1_id1%TYPE;

456: l_max_line_num NUMBER;
457: l_rec_exists_cnt NUMBER;
458: l_prev_unbilled_cnt NUMBER;
459: l_investor_agrmt_id NUMBER;
460: l_bill_freq OKC_RULES_B.object1_id1%TYPE;
461: l_primary_sty_id NUMBER;
462: l_primary_for_dep_sty_id NUMBER;
463: l_prev_khr_id okl_k_headers.id%TYPE; --dkagrawa added for bug# 4728636
464: