[Home] [Help]
3336: SELECT
3337: rulb2.RULE_INFORMATION10 arrears_yn
3338: FROM okc_k_lines_b cleb,
3339: okc_rule_groups_b rgpb,
3340: okc_rules_b rulb,
3341: okc_rules_b rulb2,
3342: okl_strm_type_b styb
3343: WHERE rgpb.chr_id IS NULL
3344: AND rgpb.dnz_chr_id = cleb.dnz_chr_id
3337: rulb2.RULE_INFORMATION10 arrears_yn
3338: FROM okc_k_lines_b cleb,
3339: okc_rule_groups_b rgpb,
3340: okc_rules_b rulb,
3341: okc_rules_b rulb2,
3342: okl_strm_type_b styb
3343: WHERE rgpb.chr_id IS NULL
3344: AND rgpb.dnz_chr_id = cleb.dnz_chr_id
3345: AND rgpb.cle_id = cleb.id
3494:
3495: -- BUG 4730646. Changing cursor.
3496: -- CURSOR lookup_csr(p_ctr_id NUMBER) IS
3497: -- SELECT rule_information1
3498: -- FROM okc_rules_b okc
3499: -- WHERE okc.dnz_chr_id = p_ctr_id
3500: -- AND okc.rule_information_category = 'LAICLC';
3501:
3502: -- Fetch contract days in a year
3614:
3615: -- Bug 4737551. Commenting below cursor and writing new select statement. SGIYER.
3616: -- CURSOR interest_rate_csr(p_ctr_id NUMBER, p_accrual_date DATE) IS
3617: -- SELECT idv.value
3618: -- FROM OKC_RULES_B rule,
3619: -- OKL_INDEX_VALUES idv,
3620: -- OKL_INDICES idx
3621: -- WHERE rule.rule_information_category = 'LAIVAR'
3622: -- AND rule.dnz_chr_id = p_ctr_id
3624: -- AND idx.ID = idv.idx_id
3625: -- AND idv.datetime_valid = (SELECT MAX(idv.datetime_valid)
3626: -- FROM OKL_INDEX_VALUES idv ,
3627: -- OKL_INDICES idx,
3628: -- OKC_RULES_B rules
3629: -- WHERE rules.rule_information_category = 'LAIVAR'
3630: -- AND rules.dnz_chr_id = p_ctr_id
3631: -- AND rules.rule_information2 = idx.id
3632: -- AND idx.id = idv.idx_id
3658: -- cursor to get adder rate
3659: -- Bug 4737551. Commenting below cursor and writing new select statement. SGIYER.
3660: -- CURSOR adder_rate_csr(p_ctr_id NUMBER) IS
3661: -- SELECT TO_NUMBER(rule_information4)
3662: -- FROM OKC_RULES_B
3663: -- WHERE rule_information_category = 'LAIVAR'
3664: -- AND dnz_chr_id = p_ctr_id;
3665:
3666: -- cursor to get adder rate
7828: l_pcnt_inv NUMBER := 0;
7829: l_stake_amnt NUMBER := 0;
7830:
7831: CURSOR l_hdrrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
7832: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
7833: chrId NUMBER) IS
7834: SELECT crl.object1_id1,
7835: crl.RULE_INFORMATION1,
7836: crl.RULE_INFORMATION2,
7840: crl.RULE_INFORMATION6,
7841: crl.RULE_INFORMATION10,
7842: crl.RULE_INFORMATION11
7843: FROM OKC_RULE_GROUPS_B crg,
7844: OKC_RULES_B crl
7845: WHERE crl.rgp_id = crg.id
7846: AND crg.RGD_CODE = rgcode
7847: AND crl.RULE_INFORMATION_CATEGORY = rlcat
7848: AND crg.dnz_chr_id = chrId;
8069: IS
8070: CURSOR l_okl_inv_payment_event_csr(p_khr_id IN NUMBER)
8071: IS
8072: SELECT rulb.rule_information2 payment_event
8073: FROM okc_rules_b rulb
8074: ,okc_rule_groups_b rgpb
8075: WHERE rgpb.dnz_chr_id = p_khr_id
8076: AND rgpb.chr_id = p_khr_id
8077: AND rgpb.rgd_code = 'LASEIR'
12908: AND khr.id = p_khr_id;
12909:
12910: CURSOR get_pmnt_arrear_flag(p_khr_id IN NUMBER, p_kle_id IN NUMBER, p_sty_id IN NUMBER) IS
12911: SELECT NVL(rl_lasll.rule_information10,'N')
12912: FROM okc_rules_b rl_lasll,
12913: okc_rule_groups_b rgp,
12914: okc_rules_b rl_laslh
12915: WHERE rl_lasll.rule_information_category = 'LASLL'
12916: AND rl_lasll.rgp_id = rgp.id
12910: CURSOR get_pmnt_arrear_flag(p_khr_id IN NUMBER, p_kle_id IN NUMBER, p_sty_id IN NUMBER) IS
12911: SELECT NVL(rl_lasll.rule_information10,'N')
12912: FROM okc_rules_b rl_lasll,
12913: okc_rule_groups_b rgp,
12914: okc_rules_b rl_laslh
12915: WHERE rl_lasll.rule_information_category = 'LASLL'
12916: AND rl_lasll.rgp_id = rgp.id
12917: AND rl_lasll.object2_id1 = rl_laslh.id
12918: AND rl_laslh.rule_information_category = 'LASLH'
13760:
13761: SELECT TO_NUMBER(laslh.object1_id1)
13762: INTO l_fee_payment_id
13763: FROM okc_rule_groups_b lalevl,
13764: okc_rules_b laslh
13765: WHERE lalevl.cle_id = p_contract_line_id
13766: AND lalevl.rgd_code = 'LALEVL'
13767: AND lalevl.id = laslh.rgp_id
13768: AND laslh.rule_information_category = 'LASLH';