[Home] [Help]
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
37: WHERE stm.khr_id = chr_so.id
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
98: WHERE stm.khr_id = chr_so.id
176: FND_NUMBER.canonical_to_number(sll.rule_information6) rent_amount
177: FROM okc_rules_b sll,
178: okc_rules_b slh,
179: okc_rule_groups_b rgp,
180: okl_strm_type_b sty,
181: okl_strm_type_tl styt
182: WHERE rgp.dnz_chr_id = p_khr_id
183: AND rgp.cle_id = p_kle_id
184: AND rgp.rgd_code= 'LALEVL'
203: sel.comments se_arrears,
204: sel.sel_id se_sel_id
205: FROM okl_strm_elements sel,
206: okl_streams stm,
207: okl_strm_type_b sty,
208: okl_strm_type_tl styt
209: WHERE stm.kle_id = p_kle_id
210: AND stm.say_code = 'CURR'
211: AND stm.purpose_code IS NULL
318: SELECT styt.name
319: FROM okc_rules_b sll,
320: okc_rules_b slh,
321: okc_rule_groups_b rgp,
322: okl_strm_type_b sty,
323: okl_strm_type_tl styt
324: WHERE rgp.dnz_chr_id = p_khr_id
325: AND rgp.cle_id = p_kle_id
326: AND rgp.rgd_code= 'LALEVL'
1263: FND_NUMBER.canonical_to_number(sll.rule_information6) rent_amount
1264: FROM okc_rules_b sll,
1265: okc_rules_b slh,
1266: okc_rule_groups_b rgp,
1267: okl_strm_type_b sty,
1268: okl_strm_type_tl styt
1269: WHERE rgp.dnz_chr_id = p_khr_id
1270: AND rgp.cle_id = p_kle_id
1271: AND rgp.rgd_code= 'LALEVL'
1291: sel.sel_id se_sel_id,
1292: sty.stream_type_purpose
1293: FROM okl_strm_elements sel,
1294: okl_streams stm,
1295: okl_strm_type_b sty,
1296: okl_strm_type_tl styt
1297: WHERE stm.kle_id = p_kle_id
1298: AND stm.say_code = 'WORK'
1299: AND DECODE(stm.purpose_code, NULL, '-99', 'REPORT') = p_purpose_code
1429: SELECT styt.name
1430: FROM okc_rules_b sll,
1431: okc_rules_b slh,
1432: okc_rule_groups_b rgp,
1433: okl_strm_type_b sty,
1434: okl_strm_type_tl styt
1435: WHERE rgp.dnz_chr_id = p_khr_id
1436: AND rgp.cle_id = p_kle_id
1437: AND rgp.rgd_code= 'LALEVL'
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
2729: WHERE cle_so.id = p_Kle_id
2730: AND cle_so.dnz_chr_id = p_khr_id
2731: AND cle_so.lse_id = lse_so.id
2732: AND cle_so.dnz_chr_id = chr_so.id
2756: DECODE(sel_amt.sel_id,NULL,'N','Y') stub,
2757: sel_amt.comments se_arrears,
2758: sel_rate.comments payment_missing_yn
2759: FROM okl_streams stm,
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,
3289: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
3290: chr_so.start_date,
3291: chr_so.end_date
3292: FROM okl_streams stm,
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,
3341: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
3342: chr_so.start_date,
3343: lse.lty_code
3344: FROM okl_streams stm,
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,
3393: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
3394: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
3395: chr_so.start_date
3396: FROM okl_streams stm,
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,
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
3444: WHERE cle_so.id = p_kle_id
3445: AND cle_so.dnz_chr_id = p_khr_id
3446: AND cle_so.lse_id = lse_so.id
3447: AND cle_so.dnz_chr_id = chr_so.id
3505: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
3506: NVL(TO_NUMBER(laptpr.rule_information1), 100) pass_through_percentage,
3507: sll.rule_information10 arrears_yn
3508: FROM okl_streams stm,
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,
4619: sty.stream_type_purpose cf_purpose,
4620: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
4621: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year
4622: FROM okl_streams stm,
4623: okl_strm_type_b sty,
4624: okl_strm_elements sel,
4625: okc_rules_b sll,
4626: okc_rules_b slh,
4627: okc_rule_groups_b rgp
4670: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
4671: cle.id kleId,
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,
4719: okc_line_styles_b lse,
4720: okc_rule_groups_b rgp,
4721: okc_rules_b slh,
4722: okc_rules_b sll,
4723: okl_strm_type_b styt
4724: WHERE cle.chr_id = p_khr_id
4725: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
4726: AND cle.lse_id = lse.id
4727: AND lse.lty_code = 'FREE_FORM1'
4774: okc_line_styles_b lse,
4775: okc_rule_groups_b rgp,
4776: okc_rules_b slh,
4777: okc_rules_b sll,
4778: okl_strm_type_b sty
4779: WHERE cle.chr_id = p_khr_id
4780: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED') -- Bug 5011438
4781: AND cle.lse_id = lse.id
4782: AND lse.lty_code = 'FREE_FORM1'
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
4805: AND cle.lse_id = lse.id
4806: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
4807: AND kle.fee_type not in ( 'SECDEPOSIT', 'INCOME' )
4841: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
4842: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
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,
6233: FND_NUMBER.canonical_to_number(sll.rule_information6) rent_amount
6234: FROM okc_rules_b sll,
6235: okc_rules_b slh,
6236: okc_rule_groups_b rgp,
6237: okl_strm_type_b sty
6238: WHERE rgp.dnz_chr_id = p_khr_id
6239: AND rgp.cle_id = p_kle_id
6240: AND rgp.rgd_code= 'LALEVL'
6241: AND rgp.id = slh.rgp_id
6256: sel.stream_element_date se_date,
6257: sel.comments se_arrears
6258: FROM okl_strm_elements sel,
6259: okl_streams stm,
6260: okl_strm_type_b sty
6261: WHERE stm.kle_id = p_kle_id
6262: AND stm.say_code = 'CURR'
6263: AND stm.active_yn = 'Y'
6264: AND stm.purpose_code IS NULL
6715: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
6716: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
6717: chr_so.start_date
6718: FROM okl_streams stm,
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,
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
6766: WHERE cle_so.id = p_kle_id
6767: AND cle_so.dnz_chr_id = p_khr_id
6768: AND cle_so.lse_id = lse_so.id
6769: AND cle_so.dnz_chr_id = chr_so.id
7445: okc_rule_groups_b rgp_so,
7446: okc_rule_groups_b rgp_pay,
7447: okc_rules_b rul_slh,
7448: okc_rules_b rul_sll,
7449: okl_strm_type_b styt
7450: WHERE rgp_so.cle_id = p_kle_id
7451: AND rgp_so.dnz_chr_id = p_khr_id
7452: AND rgp_so.rgd_code = 'SOPYSC'
7453: AND rgp_so.dnz_chr_id = rul_so.dnz_chr_id
8147: okc_line_styles_b lse,
8148: okc_rule_groups_b rgp,
8149: okc_rules_b slh,
8150: okc_rules_b sll,
8151: okl_strm_type_b styt
8152: WHERE cle.chr_id = p_khr_id
8153: AND cle.sts_code in ( 'BOOKED', 'TERMINATED' )
8154: AND cle.lse_id = lse.id
8155: AND cle.id = kleId
8177: AND cle.id IN (
8178: SELECT distinct stm.kle_id
8179: FROM okl_streams stm,
8180: okl_strm_elements ele,
8181: okl_strm_type_b sty
8182: WHERE stm.khr_id = p_khr_id
8183: AND stm.say_code = 'CURR'
8184: AND stm.active_yn = 'Y'
8185: AND stm.sty_id = sty.id
8544: sty.stream_type_purpose cf_purpose,
8545: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
8546: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year
8547: FROM okl_streams stm,
8548: okl_strm_type_b sty,
8549: okl_strm_elements sel,
8550: okc_rules_b sll,
8551: okc_rules_b slh,
8552: okc_rule_groups_b rgp
8593: sty.stream_type_purpose cf_purpose,
8594: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
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,
8637: cle.id kleId,
8638: lse.lty_code,
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,
8690: okc_line_styles_b lse,
8691: okc_rule_groups_b rgp,
8692: okc_rules_b slh,
8693: okc_rules_b sll,
8694: okl_strm_type_b sty
8695: WHERE cle.chr_id = p_khr_id
8696: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED') -- Bug 5011438
8697: AND cle.lse_id = lse.id
8698: AND lse.lty_code = 'FREE_FORM1'
8745: okc_line_styles_b lse,
8746: okc_rule_groups_b rgp,
8747: okc_rules_b slh,
8748: okc_rules_b sll,
8749: okl_strm_type_b sty
8750: WHERE cle.chr_id = p_khr_id
8751: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED') -- Bug 5011438
8752: AND cle.lse_id = lse.id
8753: AND lse.lty_code = 'FREE_FORM1'
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
8776: AND cle.lse_id = lse.id
8777: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
8778: AND kle.fee_type not in ( 'SECDEPOSIT', 'INCOME' )
9949: okc_rule_groups_b rgp_so,
9950: okc_rule_groups_b rgp_pay,
9951: okc_rules_b rul_slh,
9952: okc_rules_b rul_sll,
9953: okl_strm_type_b sty
9954: WHERE rgp_so.cle_id = p_kle_id
9955: AND rgp_so.dnz_chr_id = p_khr_id
9956: AND rgp_so.rgd_code = 'SOPYSC'
9957: AND rgp_so.dnz_chr_id = rul_so.dnz_chr_id
10046: okc_line_styles_b lse,
10047: okc_rules_b sll,
10048: okc_rules_b slh,
10049: okc_rule_groups_b rgp,
10050: okl_strm_type_b stm
10051: WHERE chr_so.id = p_khr_id
10052: and cle.sts_code in( 'COMPLETE', 'INCOMPLETE')--'ENTERED'
10053: AND cle.dnz_chr_id = chr_so.id
10054: AND cle.id = kle.id
10085: okc_line_styles_b lse,
10086: okc_rules_b sll,
10087: okc_rules_b slh,
10088: okc_rule_groups_b rgp,
10089: okl_strm_type_b stm
10090: WHERE chr_so.id = p_khr_id
10091: and cle.sts_code in( 'COMPLETE', 'INCOMPLETE')--'ENTERED'
10092: AND cle.dnz_chr_id = chr_so.id
10093: AND trunc(cle.START_DATE) = trunc(chr_so.START_DATE)
11144: FND_NUMBER.canonical_to_number(sll.rule_information6) rent_amount
11145: FROM okc_rules_b sll,
11146: okc_rules_b slh,
11147: okc_rule_groups_b rgp,
11148: okl_strm_type_b sty,
11149: okl_strm_type_tl styt
11150: WHERE rgp.dnz_chr_id = p_khr_id
11151: AND rgp.rgd_code= 'LALEVL'
11152: AND rgp.id = slh.rgp_id
11169: sty.stream_type_purpose,
11170: decode(sty.stream_type_purpose,'LOAN_PAYMENT',1,'UNSCHEDULED_PRINCIPAL_PAYMENT',2,'UNSCHEDULED_LOAN_PAYMENT',2,'VARIABLE_LOAN_PAYMENT',3,4) stream_ordr
11171: FROM okl_strm_elements sel,
11172: okl_streams stm,
11173: okl_strm_type_b sty,
11174: okl_strm_type_tl styt
11175: WHERE stm.khr_id =p_khr_id
11176: AND stm.say_code = 'CURR'
11177: AND DECODE(stm.purpose_code, NULL, '-99', 'REPORT') = '-99'
11203: TYPE loan_rec IS RECORD (se_amount NUMBER,
11204: se_date DATE,
11205: se_days NUMBER,
11206: se_arrears okl_strm_elements.comments%type,
11207: se_purpose okl_strm_type_b.stream_type_purpose%type);
11208:
11209: TYPE loan_tbl IS TABLE OF loan_rec INDEX BY BINARY_INTEGER;
11210:
11211: round_interest_tbl Okl_Streams_Pub.selv_tbl_type;