APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on OKC_RULES_B

Line 340: FROM OKC_RULES_B r

336: IS
337: -- Cursor to check factoring
338: CURSOR factoring_csr(p_ctr_id NUMBER) IS
339: SELECT rule_information1
340: FROM OKC_RULES_B r
341: WHERE r.dnz_chr_id = p_ctr_id
342: AND r.rule_information_category = 'LAFCTG';
343:
344: l_rule_information1 VARCHAR2(2000);

Line 497: okc_rules_b rul1,

493: --Bug# 14803543
494: CURSOR l_varint_sll_csr( khrid NUMBER ) IS
495: SELECT NVL(rul2.rule_information10,'N') arrears_yn
496: FROM okc_rule_groups_b rgp,
497: okc_rules_b rul1,
498: okc_rules_b rul2,
499: okl_strm_type_b sty
500: WHERE rul2.dnz_chr_id = rgp.dnz_chr_id
501: AND rul2.rule_information_category = 'LASLL'

Line 498: okc_rules_b rul2,

494: CURSOR l_varint_sll_csr( khrid NUMBER ) IS
495: SELECT NVL(rul2.rule_information10,'N') arrears_yn
496: FROM okc_rule_groups_b rgp,
497: okc_rules_b rul1,
498: okc_rules_b rul2,
499: okl_strm_type_b sty
500: WHERE rul2.dnz_chr_id = rgp.dnz_chr_id
501: AND rul2.rule_information_category = 'LASLL'
502: AND rul2.rgp_id = rgp.id

Line 6166: -- FROM OKC_RULES_B

6162: -- Commenting for Bug 4659467
6163: -- Cursor to select the interest rule i.e. whether fixed interest or variable interest
6164: -- CURSOR interest_rule_csr(p_ctr_id NUMBER) IS
6165: -- SELECT rule_information1
6166: -- FROM OKC_RULES_B
6167: -- WHERE dnz_chr_id = p_ctr_id
6168: -- AND rule_information_category = l_rule_info_cat;
6169:
6170:

Line 10142: --FROM OKC_RULES_B r

10138: -- commenting for bug# 2388940 04-Jun-02 SGIYER
10139: -- as per discussion with PM. Advance/arrears must get a value NULL.
10140: --CURSOR billing_rule_csr(p_ctr_id NUMBER) IS
10141: --SELECT object1_id1
10142: --FROM OKC_RULES_B r
10143: --WHERE r.dnz_chr_id = p_ctr_id
10144: --AND r.jtot_object1_code = 'OKX_INVRULE'
10145: --AND r.rule_information_category = 'IRE';
10146: