[Home] [Help]
28: ele.stream_element_date ele_date,
29: ele.comments
30: FROM okc_k_headers_b chr_so,
31: okc_line_styles_b lse_so,
32: okc_k_lines_b cle_so,
33: okl_strm_type_b sty,
34: okl_streams stm,
35: okl_strm_elements ele,
36: okl_strm_elements rte
89: ele.stream_element_date ele_date,
90: ele.comments
91: FROM okc_k_headers_b chr_so,
92: okc_line_styles_b lse_so,
93: okc_k_lines_b cle_so,
94: okl_strm_type_b sty,
95: okl_streams stm,
96: okl_strm_elements ele,
97: okl_strm_elements rte
1422: Select 'Y' What
1423: from dual where Exists(
1424: SELECT nvl(kle.fee_type, 'XYZ'),
1425: nvl(lse.lty_code, 'XYZ')
1426: FROM okc_k_lines_b cle,
1427: okl_k_lines kle,
1428: okc_line_styles_b lse
1429: WHERE cle.dnz_chr_id = p_khr_id
1430: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
1511: p_kle_id IN NUMBER )
1512: IS
1513: SELECT cle.orig_system_id1 orig_kle_id
1514: ,chr.orig_system_id1 orig_khr_id
1515: FROM okc_k_lines_b cle
1516: ,okc_k_headers_b chr
1517: WHERE cle.id = p_kle_id
1518: AND cle.dnz_chr_id = chr.id
1519: AND cle.orig_system_id1 IS NOT NULL;
2311:
2312: -- We here get the start date of the first SLL though there are
2313: -- more than one sll and we look for amount not null
2314: CURSOR c_rent_slls(p_khr_id okc_k_headers_b.id%TYPE,
2315: p_Kle_id okc_k_lines_b.id%TYPE,
2316: p_line_type VARCHAR2)
2317: IS
2318: SELECT trunc(FND_DATE.canonical_to_date(rul_sll.rule_information2)) start_date,
2319: NVL(rul_sll.rule_information10, 'Y') arrears_yn,
2320: khr_so.term_duration
2321: FROM okc_k_headers_b chr_so,
2322: okl_k_headers khr_so,
2323: okc_line_styles_b lse_so,
2324: okc_k_lines_b cle_so,
2325: okc_rule_groups_b rgp_pay,
2326: okc_rules_b rul_slh,
2327: okc_rules_b rul_sll,
2328: okl_strm_type_b sty
2345: ORDER BY rul_sll.rule_information2;
2346: -- Since the above SLL information are broken down into
2347: -- Stream we are good enough to consider first start date of the
2348: -- SLL
2349: CURSOR c_rent_flows(p_kle_id okc_k_lines_b.id%TYPE,
2350: p_khr_id okc_k_headers_b.id%TYPE,
2351: p_line_type VARCHAR2)
2352: IS
2353: SELECT sel_amt.id se_id,
2360: okl_strm_type_b sty,
2361: okl_strm_elements sel_amt,
2362: okl_strm_elements sel_rate,
2363: okc_k_headers_b chr_so,
2364: okc_k_lines_b cle,
2365: okc_line_styles_b lse
2366: WHERE stm.khr_id = p_khr_id
2367: AND stm.kle_id = p_kle_id
2368: AND stm.say_code = 'WORK'
2893: okl_strm_type_b sty,
2894: okl_strm_elements sel_rate,
2895: okl_strm_elements sel_amt,
2896: okc_k_headers_b chr_so,
2897: okc_k_lines_b cle,
2898: okl_k_lines kle,
2899: okc_line_styles_b lse,
2900: okc_rules_b sll,
2901: okc_rules_b slh,
2945: okl_strm_type_b sty,
2946: okl_strm_elements sel_rate,
2947: okl_strm_elements sel_amt,
2948: okc_k_headers_b chr_so,
2949: okc_k_lines_b cle,
2950: okl_k_lines kle,
2951: okc_line_styles_b lse,
2952: okc_rules_b sll,
2953: okc_rules_b slh,
2997: okl_strm_type_b sty,
2998: okl_strm_elements sel_rate,
2999: okl_strm_elements sel_amt,
3000: okc_k_headers_b chr_so,
3001: okc_k_lines_b cle,
3002: okc_line_styles_b lse,
3003: okc_rules_b sll,
3004: okc_rules_b slh,
3005: okc_rule_groups_b rgp
3035: DECODE(rul_sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
3036: cle_so.END_DATE
3037: FROM okc_k_headers_b chr_so,
3038: okc_line_styles_b lse_so,
3039: okc_k_lines_b cle_so,
3040: okc_rule_groups_b rgp_pay,
3041: okc_rules_b rul_slh,
3042: okc_rules_b rul_sll,
3043: okl_strm_type_b sty
3062: SELECT NVL(kle.amount, 0) amount,
3063: cle.start_date
3064: FROM okc_k_headers_b chr_so,
3065: okl_k_lines kle,
3066: okc_k_lines_b cle,
3067: okc_line_styles_b lse
3068: WHERE cle.chr_id = p_khr_id
3069: AND cle.lse_id = lse.id
3070: AND nvl(kle.fee_type, 'XXX') not in ( 'SECDEPOSIT', 'INCOME', 'CAPITALIZED' )
3109: okl_strm_type_b sty,
3110: okl_strm_elements sel_amt,
3111: okl_strm_elements sel,
3112: okc_k_headers_b chr_so,
3113: okc_k_lines_b cle,
3114: okc_line_styles_b lse,
3115: okl_k_lines kle,
3116: okc_rules_b sll,
3117: okc_rules_b slh,
3156: FROM okc_rules_b rul,
3157: okc_rules_b rul2,
3158: okc_rule_groups_b rgp,
3159: okc_k_headers_b chr_so,
3160: okc_k_lines_b cle,
3161: okc_line_styles_b lse
3162: WHERE cle.chr_id = p_khr_id
3163: AND cle.lse_id = lse.id
3164: AND lse.lty_code = 'FEE'
4245: from dual
4246: Where Exists(Select crl.id slh_id
4247: From OKC_RULE_GROUPS_B crg,
4248: OKC_RULES_B crl,
4249: okc_K_lines_b cle_lnk,
4250: okl_K_lines kle_roll
4251: Where crl.rgp_id = crg.id
4252: and crg.RGD_CODE = 'LALEVL'
4253: and crl.RULE_INFORMATION_CATEGORY = 'LASLL'
4272: lse.lty_code
4273: FROM okl_streams stm,
4274: okl_strm_type_b sty,
4275: okl_strm_elements sel,
4276: okc_k_lines_b cle,
4277: okc_line_styles_b lse,
4278: okc_rules_b sll,
4279: okc_rules_b slh,
4280: okc_rule_groups_b rgp
4314: cle.start_date,
4315: cle.date_terminated,
4316: cle.sts_code
4317: FROM okl_k_lines kle,
4318: okc_k_lines_b cle,
4319: okc_line_styles_b lse,
4320: okc_rule_groups_b rgp,
4321: okc_rules_b slh,
4322: okc_rules_b sll,
4346: cle.start_date start_date,
4347: kle.capital_amount,
4348: kle.capitalized_interest,
4349: kle.date_funding_expected
4350: FROM okc_k_lines_b cle,
4351: okl_K_lines kle,
4352: okc_line_styles_b lse
4353: WHERE cle.chr_id = p_khr_id
4354: AND cle.id = kle.id
4369: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
4370: cle.date_terminated,
4371: cle.sts_code
4372: FROM okl_k_lines kle,
4373: okc_k_lines_b cle,
4374: okc_line_styles_b lse,
4375: okc_rule_groups_b rgp,
4376: okc_rules_b slh,
4377: okc_rules_b sll,
4396: cle.start_date,
4397: cle.id kleId,
4398: lse.lty_code
4399: FROM okl_k_lines kle,
4400: okc_k_lines_b cle,
4401: okc_line_styles_b lse,
4402: okc_k_items cim,
4403: okl_strm_type_b sty
4404: WHERE cle.chr_id = p_khr_id
4443: NVL(TO_NUMBER(laptpr.rule_information1), 100) pass_through_percentage
4444: FROM okl_streams stm,
4445: okl_strm_type_b sty,
4446: okl_strm_elements sel,
4447: okc_k_lines_b cle,
4448: okc_line_styles_b lse,
4449: okc_rules_b sll,
4450: okc_rules_b slh,
4451: okc_rule_groups_b rgp,
4482: cle.start_date start_date
4483: FROM okc_rules_b rul,
4484: okc_rules_b rul2,
4485: okc_rule_groups_b rgp,
4486: okc_k_lines_b cle,
4487: okc_line_styles_b lse
4488: WHERE cle.chr_id = p_khr_id
4489: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
4490: AND cle.lse_id = lse.id
6329: okl_strm_type_b sty,
6330: okl_strm_elements sel_rate,
6331: okl_strm_elements sel_amt,
6332: okc_k_headers_b chr_so,
6333: okc_k_lines_b cle,
6334: okc_line_styles_b lse,
6335: okc_rules_b sll,
6336: okc_rules_b slh,
6337: okc_rule_groups_b rgp
6367: DECODE(rul_sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
6368: cle_so.END_DATE
6369: FROM okc_k_headers_b chr_so,
6370: okc_line_styles_b lse_so,
6371: okc_k_lines_b cle_so,
6372: okc_rule_groups_b rgp_pay,
6373: okc_rules_b rul_slh,
6374: okc_rules_b rul_sll,
6375: okl_strm_type_b styt
7045: cle_so.id cle_id,
7046: cle_so.start_date
7047: FROM okc_k_headers_b chr_rv,
7048: okc_line_styles_b lse_rv,
7049: okc_k_lines_b cle_rv,
7050: okc_rules_b rul_rv,
7051: okc_rule_groups_b rgp_rv,
7052: okc_line_styles_b lse_so,
7053: okc_k_lines_b cle_so,
7049: okc_k_lines_b cle_rv,
7050: okc_rules_b rul_rv,
7051: okc_rule_groups_b rgp_rv,
7052: okc_line_styles_b lse_so,
7053: okc_k_lines_b cle_so,
7054: okc_rules_b rul_so,
7055: okc_rule_groups_b rgp_so,
7056: okc_rule_groups_b rgp_pay,
7057: okc_rules_b rul_slh,
7148: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
7149: TO_NUMBER(sll.rule_information7) stub_days,
7150: TO_NUMBER(sll.rule_information8) stub_amount
7151: FROM okc_k_headers_b chr_so,
7152: okc_k_lines_b cle,
7153: okl_k_lines kle,
7154: okc_line_styles_b lse,
7155: okc_rules_b sll,
7156: okc_rules_b slh,
7752: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
7753: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
7754: cle.start_date
7755: FROM okl_k_lines kle,
7756: okc_k_lines_b cle,
7757: okc_line_styles_b lse,
7758: okc_rule_groups_b rgp,
7759: okc_rules_b slh,
7760: okc_rules_b sll,
7777:
7778: CURSOR c_asset_cost IS
7779: SELECT cle.id id,
7780: cle.start_date start_date
7781: FROM okc_k_lines_b cle,
7782: okc_line_styles_b lse
7783: WHERE cle.chr_id = p_khr_id
7784: AND cle.sts_code in ( 'BOOKED', 'TERMINATED' )
7785: AND cle.lse_id = lse.id
8180: from dual
8181: Where Exists(Select crl.id slh_id
8182: From OKC_RULE_GROUPS_B crg,
8183: OKC_RULES_B crl,
8184: okc_K_lines_b cle_lnk,
8185: okl_K_lines kle_roll
8186: Where crl.rgp_id = crg.id
8187: and crg.RGD_CODE = 'LALEVL'
8188: and crl.RULE_INFORMATION_CATEGORY = 'LASLL'
8205: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year
8206: FROM okl_streams stm,
8207: okl_strm_type_b sty,
8208: okl_strm_elements sel,
8209: okc_k_lines_b cle,
8210: okc_line_styles_b lse,
8211: okc_rules_b sll,
8212: okc_rules_b slh,
8213: okc_rule_groups_b rgp
8249: kle.fee_type
8250: FROM okl_streams stm,
8251: okl_strm_type_b sty,
8252: okl_strm_elements sel,
8253: okc_k_lines_b cle,
8254: okl_k_lines kle,
8255: okc_line_styles_b lse,
8256: okc_rules_b sll,
8257: okc_rules_b slh,
8295: cle.start_date,
8296: cle.date_terminated,
8297: cle.sts_code
8298: FROM okl_k_lines kle,
8299: okc_k_lines_b cle,
8300: okc_line_styles_b lse,
8301: okc_rule_groups_b rgp,
8302: okc_rules_b slh,
8303: okc_rules_b sll,
8327: cle.start_date start_date,
8328: kle.capital_amount,
8329: kle.capitalized_interest,
8330: kle.date_funding_expected
8331: FROM okc_k_lines_b cle,
8332: okl_K_lines kle,
8333: okc_line_styles_b lse
8334: WHERE cle.chr_id = p_khr_id
8335: AND cle.id = kle.id
8350: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
8351: cle.date_terminated,
8352: cle.sts_code
8353: FROM okl_k_lines kle,
8354: okc_k_lines_b cle,
8355: okc_line_styles_b lse,
8356: okc_rule_groups_b rgp,
8357: okc_rules_b slh,
8358: okc_rules_b sll,
8377: cle.id kleid,
8378: lse.lty_code lty_code,
8379: kle.fee_type fee_type
8380: FROM okl_k_lines kle,
8381: okc_k_lines_b cle,
8382: okc_line_styles_b lse,
8383: okc_k_items cim,
8384: okl_strm_type_b sty
8385: WHERE cle.chr_id = p_khr_id
8423: kle.fee_type
8424: FROM okc_rules_b rul,
8425: okc_rules_b rul2,
8426: okc_rule_groups_b rgp,
8427: okc_k_lines_b cle,
8428: okl_k_lines kle,
8429: okc_line_styles_b lse
8430: WHERE cle.chr_id = p_khr_id
8431: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
9554: cle_so.id cle_id,
9555: cle_so.start_date
9556: FROM okc_k_headers_b chr_rv,
9557: okc_line_styles_b lse_rv,
9558: okc_k_lines_b cle_rv,
9559: okc_rules_b rul_rv,
9560: okc_rule_groups_b rgp_rv,
9561: okc_line_styles_b lse_so,
9562: okc_k_lines_b cle_so,
9558: okc_k_lines_b cle_rv,
9559: okc_rules_b rul_rv,
9560: okc_rule_groups_b rgp_rv,
9561: okc_line_styles_b lse_so,
9562: okc_k_lines_b cle_so,
9563: okc_rules_b rul_so,
9564: okc_rule_groups_b rgp_so,
9565: okc_rule_groups_b rgp_pay,
9566: okc_rules_b rul_slh,
9655: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
9656: TO_NUMBER(sll.rule_information7) stub_days,
9657: TO_NUMBER(sll.rule_information8) stub_amount
9658: FROM okc_k_headers_b chr_so,
9659: okc_k_lines_b cle,
9660: okl_k_lines kle,
9661: okc_line_styles_b lse,
9662: okc_rules_b sll,
9663: okc_rules_b slh,
9694: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
9695: TO_NUMBER(sll.rule_information7) stub_days,
9696: TO_NUMBER(sll.rule_information8) stub_amount
9697: FROM okc_k_headers_b chr_so,
9698: okc_k_lines_b cle,
9699: okl_k_lines kle,
9700: okc_line_styles_b lse,
9701: okc_rules_b sll,
9702: okc_rules_b slh,