[Home] [Help]
778: TO_NUMBER(sll.rule_information7) stub_days,
779: TO_NUMBER(sll.rule_information8) stub_amount
780: FROM okc_k_headers_b chr_so,
781: okc_k_lines_b cle,
782: okl_k_lines kle,
783: okc_line_styles_b lse,
784: okc_rules_b sll,
785: okc_rules_b slh,
786: okc_rule_groups_b rgp,
811: kle.amount fee_amount,
812: cle.start_date fee_start_date
813: FROM okc_k_headers_b chr_so,
814: okc_k_lines_b cle,
815: okl_k_lines kle,
816: okc_line_styles_b lse
817: WHERE chr_so.id = p_khr_id
818: and cle.sts_code in( 'COMPLETE', 'INCOMPLETE')--'ENTERED'
819: AND cle.dnz_chr_id = chr_so.id
3985: /* ,tl.item_description,
3986: tl.name */
3987: --Bug# 9725362
3988: ,sts.ste_code
3989: from okl_k_lines_full_v kle,
3990: okc_line_styles_b lse,
3991: -- okc_k_lines_tl tl,
3992: okc_statuses_b sts
3993: where KLE.LSE_ID = LSE.ID
4049: FROM okc_rule_groups_b rgp,
4050: okc_rules_b rul1,
4051: okc_rules_b rul2,
4052: okc_k_lines_b cle,
4053: okl_k_lines kle,
4054: okc_line_styles_b lse,
4055: okl_strm_type_b sty
4056: WHERE rul1.rgp_id= rgp.id
4057: ANd rgp.rgd_code = 'LALEVL'
5249: FROM okc_rule_groups_b rgp,
5250: okc_rules_b rul1,
5251: okc_rules_b rul2,
5252: okc_k_lines_b cle,
5253: okl_k_lines kle,
5254: okc_line_styles_b lse
5255: WHERE
5256: rul2.dnz_chr_id = p_khr_id
5257: AND rul2.rule_information_category = 'LASLL'
5297: SELECT kle.id,
5298: NVL(kle.residual_value, 0) residual_value,
5299: cle.start_date
5300: FROM okc_k_lines_b cle,
5301: okl_k_lines kle,
5302: okc_line_styles_b lse
5303: WHERE cle.chr_id = p_khr_id
5304: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
5305: AND cle.lse_id = lse.id
5377: sty.stream_type_class stream_type_class
5378: from okl_strm_type_tl tl,
5379: okl_strm_type_v sty,
5380: okc_k_items cim,
5381: okl_k_lines_full_v kle,
5382: okc_line_styles_b ls
5383: where tl.id = sty.id
5384: and tl.language = 'US'
5385: and cim.cle_id = kle.id
6236: , lnk_cle.id kle_id
6237: , fee_cle.id fee_id
6238: , lnk_cle.date_terminated date_terminated
6239: FROM okc_k_lines_b lnk_cle
6240: , okl_k_lines fee_kle
6241: , okc_k_lines_b fee_cle
6242: , okc_line_styles_b lnk_lse
6243: , okc_statuses_b sts
6244: WHERE lnk_cle.dnz_chr_id = cp_chr_id
7040: FROM okc_rules_b rul,
7041: okc_rules_b rul2,
7042: okc_rule_groups_b rgp,
7043: okc_k_lines_b cle,
7044: okl_k_lines kle
7045: WHERE cle.id = p_kle_id
7046: AND cle.sts_code IN ('NEW', 'INCOMPLETE', 'PASSED', 'COMPLETE')
7047: AND kle.id = cle.id
7048: AND kle.fee_type NOT IN
8036: FROM okc_rule_groups_b rgp,
8037: okc_rules_b rul1,
8038: okc_rules_b rul2,
8039: okc_k_lines_b cle,
8040: okl_k_lines kle,
8041: okc_line_styles_b lse,
8042: okl_strm_type_b sty
8043: WHERE rul2.dnz_chr_id = p_khr_id
8044: AND rul2.rule_information_category = 'LASLL'
8078: kle.origination_income origination_income,
8079: kle.amount fee_amount,
8080: 'INCOME_AMORT' fee_line_level_type
8081: FROM okc_k_lines_b cle,
8082: okl_k_lines kle,
8083: okc_line_styles_b lse,
8084: okl_strm_type_b sty,
8085: okc_rule_groups_b rgp,
8086: okc_rules_b rul1
8119: FROM okc_rule_groups_b rgp,
8120: okc_rules_b rul1,
8121: okc_rules_b rul2,
8122: okc_k_lines_b cle,
8123: okl_k_lines kle,
8124: okc_line_styles_b lse,
8125: okl_strm_type_b sty
8126: WHERE
8127: rul2.dnz_chr_id = p_khr_id
8184: kle.amount,
8185: kle.capital_amount,
8186: kle.capitalized_interest
8187: FROM okc_k_lines_b cle,
8188: okl_k_lines kle,
8189: okc_line_styles_b lse
8190: WHERE cle.dnz_chr_id = p_khr_id
8191: -- 12944979: For Terminated lines, copy_accrual_streams_isg will syncup
8192: AND cle.sts_code IN ('PASSED', 'COMPLETE') --, 'TERMINATED')
8224: From OKC_RULE_GROUPS_B crg,
8225: OKC_RULES_B crl,
8226: okc_rules_b slh,
8227: okc_K_lines_b cle_lnk,
8228: okl_K_lines kle_roll
8229: Where slh.rgp_id = crg.id
8230: and crg.RGD_CODE = 'LALEVL'
8231: and crl.RULE_INFORMATION_CATEGORY = 'LASLL'
8232: and slh.RULE_INFORMATION_CATEGORY = 'LASLH'
8258: SELECT kle.id,
8259: nvl(kle.fee_type, 'LINK_FEE_ASSET') fee_type,
8260: lse.lty_code
8261: FROM okc_k_lines_b cle,
8262: okl_k_lines kle,
8263: okc_line_styles_b lse
8264: WHERE cle.dnz_chr_id = p_khr_id
8265: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
8266: AND cle.id = kle.id
8336: Select 'Y'
8337: From dual
8338: where Exists(
8339: select kle.id
8340: from okl_k_lines_full_v kle,
8341: okc_line_styles_b lse,
8342: okc_statuses_b sts
8343: where KLE.LSE_ID = LSE.ID
8344: and lse.lty_code = 'SUBSIDY'
13489: from dual where Exists(
13490: SELECT nvl(kle.fee_type, 'XYZ'),
13491: nvl(lse.lty_code, 'XYZ')
13492: FROM okc_k_lines_b cle,
13493: okl_k_lines kle,
13494: okc_line_styles_b lse
13495: WHERE cle.dnz_chr_id = p_khr_id
13496: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
13497: AND cle.lse_id = lse.id
13657: x_msg_data OUT NOCOPY VARCHAR2) IS
13658:
13659: cursor l_line_csr IS
13660: select kle.id
13661: from okl_k_lines_full_v kle,
13662: okc_line_styles_b lse,
13663: okc_statuses_b sts
13664: where KLE.LSE_ID = LSE.ID
13665: and lse.lty_code in ('FREE_FORM1', 'FEE')
14076: FROM okc_rule_groups_b rgp,
14077: okc_rules_b rul1,
14078: okc_rules_b rul2,
14079: okc_k_lines_b cle,
14080: okl_k_lines kle,
14081: okc_line_styles_b lse
14082: WHERE
14083: rul2.dnz_chr_id = p_khr_id
14084: AND rul2.rule_information_category = 'LASLL'
14306: FROM okc_rule_groups_b rgp,
14307: okc_rules_b rul1,
14308: okc_rules_b rul2,
14309: okc_k_lines_b cle,
14310: okl_k_lines kle,
14311: okc_line_styles_b lse,
14312: okl_strm_type_b sty
14313: WHERE
14314: rul2.dnz_chr_id = p_khr_id