[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
1407: Select 'Y' What
1408: from dual where Exists(
1409: SELECT nvl(kle.fee_type, 'XYZ'),
1410: nvl(lse.lty_code, 'XYZ')
1411: FROM okc_k_lines_b cle,
1412: okl_k_lines kle,
1413: okc_line_styles_b lse
1414: WHERE cle.dnz_chr_id = p_khr_id
1415: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
2711:
2712: -- We here get the start date of the first SLL though there are
2713: -- more than one sll and we look for amount not null
2714: CURSOR c_rent_slls(p_khr_id okc_k_headers_b.id%TYPE,
2715: p_Kle_id okc_k_lines_b.id%TYPE,
2716: p_line_type VARCHAR2)
2717: IS
2718: SELECT trunc(FND_DATE.canonical_to_date(rul_sll.rule_information2)) start_date,
2719: NVL(rul_sll.rule_information10, 'Y') arrears_yn,
2720: khr_so.term_duration
2721: FROM okc_k_headers_b chr_so,
2722: okl_k_headers khr_so,
2723: okc_line_styles_b lse_so,
2724: okc_k_lines_b cle_so,
2725: okc_rule_groups_b rgp_pay,
2726: okc_rules_b rul_slh,
2727: okc_rules_b rul_sll,
2728: okl_strm_type_b sty
2745: ORDER BY rul_sll.rule_information2;
2746: -- Since the above SLL information are broken down into
2747: -- Stream we are good enough to consider first start date of the
2748: -- SLL
2749: CURSOR c_rent_flows(p_kle_id okc_k_lines_b.id%TYPE,
2750: p_khr_id okc_k_headers_b.id%TYPE,
2751: p_line_type VARCHAR2)
2752: IS
2753: SELECT sel_amt.id se_id,
2760: okl_strm_type_b sty,
2761: okl_strm_elements sel_amt,
2762: okl_strm_elements sel_rate,
2763: okc_k_headers_b chr_so,
2764: okc_k_lines_b cle,
2765: okc_line_styles_b lse
2766: WHERE stm.khr_id = p_khr_id
2767: AND stm.kle_id = p_kle_id
2768: AND stm.say_code = 'WORK'
3293: okl_strm_type_b sty,
3294: okl_strm_elements sel_rate,
3295: okl_strm_elements sel_amt,
3296: okc_k_headers_b chr_so,
3297: okc_k_lines_b cle,
3298: okl_k_lines kle,
3299: okc_line_styles_b lse,
3300: okc_rules_b sll,
3301: okc_rules_b slh,
3345: okl_strm_type_b sty,
3346: okl_strm_elements sel_rate,
3347: okl_strm_elements sel_amt,
3348: okc_k_headers_b chr_so,
3349: okc_k_lines_b cle,
3350: okl_k_lines kle,
3351: okc_line_styles_b lse,
3352: okc_rules_b sll,
3353: okc_rules_b slh,
3397: okl_strm_type_b sty,
3398: okl_strm_elements sel_rate,
3399: okl_strm_elements sel_amt,
3400: okc_k_headers_b chr_so,
3401: okc_k_lines_b cle,
3402: okc_line_styles_b lse,
3403: okc_rules_b sll,
3404: okc_rules_b slh,
3405: okc_rule_groups_b rgp
3435: DECODE(rul_sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
3436: cle_so.END_DATE
3437: FROM okc_k_headers_b chr_so,
3438: okc_line_styles_b lse_so,
3439: okc_k_lines_b cle_so,
3440: okc_rule_groups_b rgp_pay,
3441: okc_rules_b rul_slh,
3442: okc_rules_b rul_sll,
3443: okl_strm_type_b sty
3462: SELECT NVL(kle.amount, 0) amount,
3463: cle.start_date
3464: FROM okc_k_headers_b chr_so,
3465: okl_k_lines kle,
3466: okc_k_lines_b cle,
3467: okc_line_styles_b lse
3468: WHERE cle.chr_id = p_khr_id
3469: AND cle.lse_id = lse.id
3470: AND nvl(kle.fee_type, 'XXX') not in ( 'SECDEPOSIT', 'INCOME', 'CAPITALIZED' )
3509: okl_strm_type_b sty,
3510: okl_strm_elements sel_amt,
3511: okl_strm_elements sel,
3512: okc_k_headers_b chr_so,
3513: okc_k_lines_b cle,
3514: okc_line_styles_b lse,
3515: okl_k_lines kle,
3516: okc_rules_b sll,
3517: okc_rules_b slh,
3556: FROM okc_rules_b rul,
3557: okc_rules_b rul2,
3558: okc_rule_groups_b rgp,
3559: okc_k_headers_b chr_so,
3560: okc_k_lines_b cle,
3561: okc_line_styles_b lse
3562: WHERE cle.chr_id = p_khr_id
3563: AND cle.lse_id = lse.id
3564: AND lse.lty_code = 'FEE'
4645: from dual
4646: Where Exists(Select crl.id slh_id
4647: From OKC_RULE_GROUPS_B crg,
4648: OKC_RULES_B crl,
4649: okc_K_lines_b cle_lnk,
4650: okl_K_lines kle_roll
4651: Where crl.rgp_id = crg.id
4652: and crg.RGD_CODE = 'LALEVL'
4653: and crl.RULE_INFORMATION_CATEGORY = 'LASLL'
4672: lse.lty_code
4673: FROM okl_streams stm,
4674: okl_strm_type_b sty,
4675: okl_strm_elements sel,
4676: okc_k_lines_b cle,
4677: okc_line_styles_b lse,
4678: okc_rules_b sll,
4679: okc_rules_b slh,
4680: okc_rule_groups_b rgp
4714: cle.start_date,
4715: cle.date_terminated,
4716: cle.sts_code
4717: FROM okl_k_lines kle,
4718: okc_k_lines_b cle,
4719: okc_line_styles_b lse,
4720: okc_rule_groups_b rgp,
4721: okc_rules_b slh,
4722: okc_rules_b sll,
4746: cle.start_date start_date,
4747: kle.capital_amount,
4748: kle.capitalized_interest,
4749: kle.date_funding_expected
4750: FROM okc_k_lines_b cle,
4751: okl_K_lines kle,
4752: okc_line_styles_b lse
4753: WHERE cle.chr_id = p_khr_id
4754: AND cle.id = kle.id
4769: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
4770: cle.date_terminated,
4771: cle.sts_code
4772: FROM okl_k_lines kle,
4773: okc_k_lines_b cle,
4774: okc_line_styles_b lse,
4775: okc_rule_groups_b rgp,
4776: okc_rules_b slh,
4777: okc_rules_b sll,
4796: cle.start_date,
4797: cle.id kleId,
4798: lse.lty_code
4799: FROM okl_k_lines kle,
4800: okc_k_lines_b cle,
4801: okc_line_styles_b lse,
4802: okc_k_items cim,
4803: okl_strm_type_b sty
4804: WHERE cle.chr_id = p_khr_id
4843: NVL(TO_NUMBER(laptpr.rule_information1), 100) pass_through_percentage
4844: FROM okl_streams stm,
4845: okl_strm_type_b sty,
4846: okl_strm_elements sel,
4847: okc_k_lines_b cle,
4848: okc_line_styles_b lse,
4849: okc_rules_b sll,
4850: okc_rules_b slh,
4851: okc_rule_groups_b rgp,
4882: cle.start_date start_date
4883: FROM okc_rules_b rul,
4884: okc_rules_b rul2,
4885: okc_rule_groups_b rgp,
4886: okc_k_lines_b cle,
4887: okc_line_styles_b lse
4888: WHERE cle.chr_id = p_khr_id
4889: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
4890: AND cle.lse_id = lse.id
6719: okl_strm_type_b sty,
6720: okl_strm_elements sel_rate,
6721: okl_strm_elements sel_amt,
6722: okc_k_headers_b chr_so,
6723: okc_k_lines_b cle,
6724: okc_line_styles_b lse,
6725: okc_rules_b sll,
6726: okc_rules_b slh,
6727: okc_rule_groups_b rgp
6757: DECODE(rul_sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
6758: cle_so.END_DATE
6759: FROM okc_k_headers_b chr_so,
6760: okc_line_styles_b lse_so,
6761: okc_k_lines_b cle_so,
6762: okc_rule_groups_b rgp_pay,
6763: okc_rules_b rul_slh,
6764: okc_rules_b rul_sll,
6765: okl_strm_type_b styt
7435: cle_so.id cle_id,
7436: cle_so.start_date
7437: FROM okc_k_headers_b chr_rv,
7438: okc_line_styles_b lse_rv,
7439: okc_k_lines_b cle_rv,
7440: okc_rules_b rul_rv,
7441: okc_rule_groups_b rgp_rv,
7442: okc_line_styles_b lse_so,
7443: okc_k_lines_b cle_so,
7439: okc_k_lines_b cle_rv,
7440: okc_rules_b rul_rv,
7441: okc_rule_groups_b rgp_rv,
7442: okc_line_styles_b lse_so,
7443: okc_k_lines_b cle_so,
7444: okc_rules_b rul_so,
7445: okc_rule_groups_b rgp_so,
7446: okc_rule_groups_b rgp_pay,
7447: okc_rules_b rul_slh,
7538: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
7539: TO_NUMBER(sll.rule_information7) stub_days,
7540: TO_NUMBER(sll.rule_information8) stub_amount
7541: FROM okc_k_headers_b chr_so,
7542: okc_k_lines_b cle,
7543: okl_k_lines kle,
7544: okc_line_styles_b lse,
7545: okc_rules_b sll,
7546: okc_rules_b slh,
8142: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
8143: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
8144: cle.start_date
8145: FROM okl_k_lines kle,
8146: okc_k_lines_b cle,
8147: okc_line_styles_b lse,
8148: okc_rule_groups_b rgp,
8149: okc_rules_b slh,
8150: okc_rules_b sll,
8167:
8168: CURSOR c_asset_cost IS
8169: SELECT cle.id id,
8170: cle.start_date start_date
8171: FROM okc_k_lines_b cle,
8172: okc_line_styles_b lse
8173: WHERE cle.chr_id = p_khr_id
8174: AND cle.sts_code in ( 'BOOKED', 'TERMINATED' )
8175: AND cle.lse_id = lse.id
8570: from dual
8571: Where Exists(Select crl.id slh_id
8572: From OKC_RULE_GROUPS_B crg,
8573: OKC_RULES_B crl,
8574: okc_K_lines_b cle_lnk,
8575: okl_K_lines kle_roll
8576: Where crl.rgp_id = crg.id
8577: and crg.RGD_CODE = 'LALEVL'
8578: and crl.RULE_INFORMATION_CATEGORY = 'LASLL'
8595: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year
8596: FROM okl_streams stm,
8597: okl_strm_type_b sty,
8598: okl_strm_elements sel,
8599: okc_k_lines_b cle,
8600: okc_line_styles_b lse,
8601: okc_rules_b sll,
8602: okc_rules_b slh,
8603: okc_rule_groups_b rgp
8639: kle.fee_type
8640: FROM okl_streams stm,
8641: okl_strm_type_b sty,
8642: okl_strm_elements sel,
8643: okc_k_lines_b cle,
8644: okl_k_lines kle,
8645: okc_line_styles_b lse,
8646: okc_rules_b sll,
8647: okc_rules_b slh,
8685: cle.start_date,
8686: cle.date_terminated,
8687: cle.sts_code
8688: FROM okl_k_lines kle,
8689: okc_k_lines_b cle,
8690: okc_line_styles_b lse,
8691: okc_rule_groups_b rgp,
8692: okc_rules_b slh,
8693: okc_rules_b sll,
8717: cle.start_date start_date,
8718: kle.capital_amount,
8719: kle.capitalized_interest,
8720: kle.date_funding_expected
8721: FROM okc_k_lines_b cle,
8722: okl_K_lines kle,
8723: okc_line_styles_b lse
8724: WHERE cle.chr_id = p_khr_id
8725: AND cle.id = kle.id
8740: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) months_per_period,
8741: cle.date_terminated,
8742: cle.sts_code
8743: FROM okl_k_lines kle,
8744: okc_k_lines_b cle,
8745: okc_line_styles_b lse,
8746: okc_rule_groups_b rgp,
8747: okc_rules_b slh,
8748: okc_rules_b sll,
8767: cle.id kleid,
8768: lse.lty_code lty_code,
8769: kle.fee_type fee_type
8770: FROM okl_k_lines kle,
8771: okc_k_lines_b cle,
8772: okc_line_styles_b lse,
8773: okc_k_items cim,
8774: okl_strm_type_b sty
8775: WHERE cle.chr_id = p_khr_id
8813: kle.fee_type
8814: FROM okc_rules_b rul,
8815: okc_rules_b rul2,
8816: okc_rule_groups_b rgp,
8817: okc_k_lines_b cle,
8818: okl_k_lines kle,
8819: okc_line_styles_b lse
8820: WHERE cle.chr_id = p_khr_id
8821: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
9939: cle_so.id cle_id,
9940: cle_so.start_date
9941: FROM okc_k_headers_b chr_rv,
9942: okc_line_styles_b lse_rv,
9943: okc_k_lines_b cle_rv,
9944: okc_rules_b rul_rv,
9945: okc_rule_groups_b rgp_rv,
9946: okc_line_styles_b lse_so,
9947: okc_k_lines_b cle_so,
9943: okc_k_lines_b cle_rv,
9944: okc_rules_b rul_rv,
9945: okc_rule_groups_b rgp_rv,
9946: okc_line_styles_b lse_so,
9947: okc_k_lines_b cle_so,
9948: okc_rules_b rul_so,
9949: okc_rule_groups_b rgp_so,
9950: okc_rule_groups_b rgp_pay,
9951: okc_rules_b rul_slh,
10040: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
10041: TO_NUMBER(sll.rule_information7) stub_days,
10042: TO_NUMBER(sll.rule_information8) stub_amount
10043: FROM okc_k_headers_b chr_so,
10044: okc_k_lines_b cle,
10045: okl_k_lines kle,
10046: okc_line_styles_b lse,
10047: okc_rules_b sll,
10048: okc_rules_b slh,
10079: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
10080: TO_NUMBER(sll.rule_information7) stub_days,
10081: TO_NUMBER(sll.rule_information8) stub_amount
10082: FROM okc_k_headers_b chr_so,
10083: okc_k_lines_b cle,
10084: okl_k_lines kle,
10085: okc_line_styles_b lse,
10086: okc_rules_b sll,
10087: okc_rules_b slh,