[Home] [Help]
3335: CURSOR adv_arr_csr IS
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
7827: l_cap_amnt NUMBER := 0;
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,
7839: crl.RULE_INFORMATION5,
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
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'
8078: AND rgpb.id = rulb.rgp_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
12917: AND rl_lasll.object2_id1 = rl_laslh.id
13759: END IF;
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