APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKC_RULES_B

Line 2876: okc_rules_b rulb,

2872: SELECT
2873: rulb2.RULE_INFORMATION10 arrears_yn
2874: FROM okc_k_lines_b cleb,
2875: okc_rule_groups_b rgpb,
2876: okc_rules_b rulb,
2877: okc_rules_b rulb2,
2878: okl_strm_type_b styb
2879: WHERE rgpb.chr_id IS NULL
2880: AND rgpb.dnz_chr_id = cleb.dnz_chr_id

Line 2877: okc_rules_b rulb2,

2873: rulb2.RULE_INFORMATION10 arrears_yn
2874: FROM okc_k_lines_b cleb,
2875: okc_rule_groups_b rgpb,
2876: okc_rules_b rulb,
2877: okc_rules_b rulb2,
2878: okl_strm_type_b styb
2879: WHERE rgpb.chr_id IS NULL
2880: AND rgpb.dnz_chr_id = cleb.dnz_chr_id
2881: AND rgpb.cle_id = cleb.id

Line 3034: -- FROM okc_rules_b okc

3030:
3031: -- BUG 4730646. Changing cursor.
3032: -- CURSOR lookup_csr(p_ctr_id NUMBER) IS
3033: -- SELECT rule_information1
3034: -- FROM okc_rules_b okc
3035: -- WHERE okc.dnz_chr_id = p_ctr_id
3036: -- AND okc.rule_information_category = 'LAICLC';
3037:
3038: -- Fetch contract days in a year

Line 3154: -- FROM OKC_RULES_B rule,

3150:
3151: -- Bug 4737551. Commenting below cursor and writing new select statement. SGIYER.
3152: -- CURSOR interest_rate_csr(p_ctr_id NUMBER, p_accrual_date DATE) IS
3153: -- SELECT idv.value
3154: -- FROM OKC_RULES_B rule,
3155: -- OKL_INDEX_VALUES idv,
3156: -- OKL_INDICES idx
3157: -- WHERE rule.rule_information_category = 'LAIVAR'
3158: -- AND rule.dnz_chr_id = p_ctr_id

Line 3164: -- OKC_RULES_B rules

3160: -- AND idx.ID = idv.idx_id
3161: -- AND idv.datetime_valid = (SELECT MAX(idv.datetime_valid)
3162: -- FROM OKL_INDEX_VALUES idv ,
3163: -- OKL_INDICES idx,
3164: -- OKC_RULES_B rules
3165: -- WHERE rules.rule_information_category = 'LAIVAR'
3166: -- AND rules.dnz_chr_id = p_ctr_id
3167: -- AND rules.rule_information2 = idx.id
3168: -- AND idx.id = idv.idx_id

Line 3198: -- FROM OKC_RULES_B

3194: -- cursor to get adder rate
3195: -- Bug 4737551. Commenting below cursor and writing new select statement. SGIYER.
3196: -- CURSOR adder_rate_csr(p_ctr_id NUMBER) IS
3197: -- SELECT TO_NUMBER(rule_information4)
3198: -- FROM OKC_RULES_B
3199: -- WHERE rule_information_category = 'LAIVAR'
3200: -- AND dnz_chr_id = p_ctr_id;
3201:
3202: -- cursor to get adder rate

Line 7234: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

7230: l_pcnt_inv NUMBER := 0;
7231: l_stake_amnt NUMBER := 0;
7232:
7233: CURSOR l_hdrrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
7234: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
7235: chrId NUMBER) IS
7236: SELECT crl.object1_id1,
7237: crl.RULE_INFORMATION1,
7238: crl.RULE_INFORMATION2,

Line 7246: OKC_RULES_B crl

7242: crl.RULE_INFORMATION6,
7243: crl.RULE_INFORMATION10,
7244: crl.RULE_INFORMATION11
7245: FROM OKC_RULE_GROUPS_B crg,
7246: OKC_RULES_B crl
7247: WHERE crl.rgp_id = crg.id
7248: AND crg.RGD_CODE = rgcode
7249: AND crl.RULE_INFORMATION_CATEGORY = rlcat
7250: AND crg.dnz_chr_id = chrId;

Line 7424: FROM okc_rules_b rulb

7420: IS
7421: CURSOR l_okl_inv_payment_event_csr(p_khr_id IN NUMBER)
7422: IS
7423: SELECT rulb.rule_information2 payment_event
7424: FROM okc_rules_b rulb
7425: ,okc_rule_groups_b rgpb
7426: WHERE rgpb.dnz_chr_id = p_khr_id
7427: AND rgpb.chr_id = p_khr_id
7428: AND rgpb.rgd_code = 'LASEIR'

Line 12532: okc_rules_b laslh

12528:
12529: SELECT TO_NUMBER(laslh.object1_id1)
12530: INTO l_fee_payment_id
12531: FROM okc_rule_groups_b lalevl,
12532: okc_rules_b laslh
12533: WHERE lalevl.cle_id = p_contract_line_id
12534: AND lalevl.rgd_code = 'LALEVL'
12535: AND lalevl.id = laslh.rgp_id
12536: AND laslh.rule_information_category = 'LASLH';