[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'
1270: FND_NUMBER.canonical_to_number(sll.rule_information6) rent_amount
1271: FROM okc_rules_b sll,
1272: okc_rules_b slh,
1273: okc_rule_groups_b rgp,
1274: okl_strm_type_b sty,
1275: okl_strm_type_tl styt
1276: WHERE rgp.dnz_chr_id = p_khr_id
1277: AND rgp.cle_id = p_kle_id
1278: AND rgp.rgd_code= 'LALEVL'
1304: 'PRINCIPAL_PAYMENT', 'PRIN_PMNT',
1305: 'RENT' ) cf_purpose
1306: FROM okl_strm_elements sel,
1307: okl_streams stm,
1308: okl_strm_type_b sty,
1309: okl_strm_type_tl styt
1310: WHERE stm.kle_id = p_kle_id
1311: AND stm.say_code = 'WORK'
1312: AND DECODE(stm.purpose_code, NULL, '-99', 'REPORT') = p_purpose_code
1444: SELECT styt.name
1445: FROM okc_rules_b sll,
1446: okc_rules_b slh,
1447: okc_rule_groups_b rgp,
1448: okl_strm_type_b sty,
1449: okl_strm_type_tl styt
1450: WHERE rgp.dnz_chr_id = p_khr_id
1451: AND rgp.cle_id = p_kle_id
1452: AND rgp.rgd_code= 'LALEVL'
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
2329: WHERE cle_so.id = p_Kle_id
2330: AND cle_so.dnz_chr_id = p_khr_id
2331: AND cle_so.lse_id = lse_so.id
2332: AND cle_so.dnz_chr_id = chr_so.id
2356: DECODE(sel_amt.sel_id,NULL,'N','Y') stub,
2357: sel_amt.comments se_arrears,
2358: sel_rate.comments payment_missing_yn
2359: FROM okl_streams stm,
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,
2889: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
2890: chr_so.start_date,
2891: chr_so.end_date
2892: FROM okl_streams stm,
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,
2941: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
2942: chr_so.start_date,
2943: lse.lty_code
2944: FROM okl_streams stm,
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,
2993: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
2994: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
2995: chr_so.start_date
2996: FROM okl_streams stm,
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,
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
3044: WHERE cle_so.id = p_kle_id
3045: AND cle_so.dnz_chr_id = p_khr_id
3046: AND cle_so.lse_id = lse_so.id
3047: AND cle_so.dnz_chr_id = chr_so.id
3105: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
3106: NVL(TO_NUMBER(laptpr.rule_information1), 100) pass_through_percentage,
3107: sll.rule_information10 arrears_yn
3108: FROM okl_streams stm,
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,
4219: sty.stream_type_purpose cf_purpose,
4220: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
4221: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year
4222: FROM okl_streams stm,
4223: okl_strm_type_b sty,
4224: okl_strm_elements sel,
4225: okc_rules_b sll,
4226: okc_rules_b slh,
4227: okc_rule_groups_b rgp
4270: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
4271: cle.id kleId,
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,
4319: okc_line_styles_b lse,
4320: okc_rule_groups_b rgp,
4321: okc_rules_b slh,
4322: okc_rules_b sll,
4323: okl_strm_type_b styt
4324: WHERE cle.chr_id = p_khr_id
4325: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
4326: AND cle.lse_id = lse.id
4327: AND lse.lty_code = 'FREE_FORM1'
4374: okc_line_styles_b lse,
4375: okc_rule_groups_b rgp,
4376: okc_rules_b slh,
4377: okc_rules_b sll,
4378: okl_strm_type_b sty
4379: WHERE cle.chr_id = p_khr_id
4380: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED') -- Bug 5011438
4381: AND cle.lse_id = lse.id
4382: AND lse.lty_code = 'FREE_FORM1'
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
4405: AND cle.lse_id = lse.id
4406: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
4407: AND kle.fee_type not in ( 'SECDEPOSIT', 'INCOME' )
4441: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
4442: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
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,
5843: FND_NUMBER.canonical_to_number(sll.rule_information6) rent_amount
5844: FROM okc_rules_b sll,
5845: okc_rules_b slh,
5846: okc_rule_groups_b rgp,
5847: okl_strm_type_b sty
5848: WHERE rgp.dnz_chr_id = p_khr_id
5849: AND rgp.cle_id = p_kle_id
5850: AND rgp.rgd_code= 'LALEVL'
5851: AND rgp.id = slh.rgp_id
5866: sel.stream_element_date se_date,
5867: sel.comments se_arrears
5868: FROM okl_strm_elements sel,
5869: okl_streams stm,
5870: okl_strm_type_b sty
5871: WHERE stm.kle_id = p_kle_id
5872: AND stm.say_code = 'CURR'
5873: AND stm.active_yn = 'Y'
5874: AND stm.purpose_code IS NULL
6325: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
6326: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year,
6327: chr_so.start_date
6328: FROM okl_streams stm,
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,
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
6376: WHERE cle_so.id = p_kle_id
6377: AND cle_so.dnz_chr_id = p_khr_id
6378: AND cle_so.lse_id = lse_so.id
6379: AND cle_so.dnz_chr_id = chr_so.id
7055: okc_rule_groups_b rgp_so,
7056: okc_rule_groups_b rgp_pay,
7057: okc_rules_b rul_slh,
7058: okc_rules_b rul_sll,
7059: okl_strm_type_b styt
7060: WHERE rgp_so.cle_id = p_kle_id
7061: AND rgp_so.dnz_chr_id = p_khr_id
7062: AND rgp_so.rgd_code = 'SOPYSC'
7063: AND rgp_so.dnz_chr_id = rul_so.dnz_chr_id
7757: okc_line_styles_b lse,
7758: okc_rule_groups_b rgp,
7759: okc_rules_b slh,
7760: okc_rules_b sll,
7761: okl_strm_type_b styt
7762: WHERE cle.chr_id = p_khr_id
7763: AND cle.sts_code in ( 'BOOKED', 'TERMINATED' )
7764: AND cle.lse_id = lse.id
7765: AND cle.id = kleId
7787: AND cle.id IN (
7788: SELECT distinct stm.kle_id
7789: FROM okl_streams stm,
7790: okl_strm_elements ele,
7791: okl_strm_type_b sty
7792: WHERE stm.khr_id = p_khr_id
7793: AND stm.say_code = 'CURR'
7794: AND stm.active_yn = 'Y'
7795: AND stm.sty_id = sty.id
8154: sty.stream_type_purpose cf_purpose,
8155: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
8156: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year
8157: FROM okl_streams stm,
8158: okl_strm_type_b sty,
8159: okl_strm_elements sel,
8160: okc_rules_b sll,
8161: okc_rules_b slh,
8162: okc_rule_groups_b rgp
8203: sty.stream_type_purpose cf_purpose,
8204: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
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,
8247: cle.id kleId,
8248: lse.lty_code,
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,
8300: okc_line_styles_b lse,
8301: okc_rule_groups_b rgp,
8302: okc_rules_b slh,
8303: okc_rules_b sll,
8304: okl_strm_type_b sty
8305: WHERE cle.chr_id = p_khr_id
8306: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED') -- Bug 5011438
8307: AND cle.lse_id = lse.id
8308: AND lse.lty_code = 'FREE_FORM1'
8355: okc_line_styles_b lse,
8356: okc_rule_groups_b rgp,
8357: okc_rules_b slh,
8358: okc_rules_b sll,
8359: okl_strm_type_b sty
8360: WHERE cle.chr_id = p_khr_id
8361: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED') -- Bug 5011438
8362: AND cle.lse_id = lse.id
8363: AND lse.lty_code = 'FREE_FORM1'
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
8386: AND cle.lse_id = lse.id
8387: AND cle.sts_code IN ('PASSED', 'COMPLETE', 'TERMINATED')
8388: AND kle.fee_type not in ( 'SECDEPOSIT', 'INCOME' )
9564: okc_rule_groups_b rgp_so,
9565: okc_rule_groups_b rgp_pay,
9566: okc_rules_b rul_slh,
9567: okc_rules_b rul_sll,
9568: okl_strm_type_b sty
9569: WHERE rgp_so.cle_id = p_kle_id
9570: AND rgp_so.dnz_chr_id = p_khr_id
9571: AND rgp_so.rgd_code = 'SOPYSC'
9572: AND rgp_so.dnz_chr_id = rul_so.dnz_chr_id
9661: okc_line_styles_b lse,
9662: okc_rules_b sll,
9663: okc_rules_b slh,
9664: okc_rule_groups_b rgp,
9665: okl_strm_type_b stm
9666: WHERE chr_so.id = p_khr_id
9667: and cle.sts_code in( 'COMPLETE', 'INCOMPLETE')--'ENTERED'
9668: AND cle.dnz_chr_id = chr_so.id
9669: AND cle.id = kle.id
9700: okc_line_styles_b lse,
9701: okc_rules_b sll,
9702: okc_rules_b slh,
9703: okc_rule_groups_b rgp,
9704: okl_strm_type_b stm
9705: WHERE chr_so.id = p_khr_id
9706: and cle.sts_code in( 'COMPLETE', 'INCOMPLETE')--'ENTERED'
9707: AND cle.dnz_chr_id = chr_so.id
9708: AND trunc(cle.START_DATE) = trunc(chr_so.START_DATE)
10766: FND_NUMBER.canonical_to_number(sll.rule_information6) rent_amount
10767: FROM okc_rules_b sll,
10768: okc_rules_b slh,
10769: okc_rule_groups_b rgp,
10770: okl_strm_type_b sty,
10771: okl_strm_type_tl styt
10772: WHERE rgp.dnz_chr_id = p_khr_id
10773: AND rgp.rgd_code= 'LALEVL'
10774: AND rgp.id = slh.rgp_id
10791: sty.stream_type_purpose,
10792: decode(sty.stream_type_purpose,'LOAN_PAYMENT',1,'UNSCHEDULED_PRINCIPAL_PAYMENT',2,'UNSCHEDULED_LOAN_PAYMENT',2,'VARIABLE_LOAN_PAYMENT',3,4) stream_ordr
10793: FROM okl_strm_elements sel,
10794: okl_streams stm,
10795: okl_strm_type_b sty,
10796: okl_strm_type_tl styt
10797: WHERE stm.khr_id =p_khr_id
10798: AND stm.say_code = 'CURR'
10799: AND DECODE(stm.purpose_code, NULL, '-99', 'REPORT') = '-99'
10825: TYPE loan_rec IS RECORD (se_amount NUMBER,
10826: se_date DATE,
10827: se_days NUMBER,
10828: se_arrears okl_strm_elements.comments%type,
10829: se_purpose okl_strm_type_b.stream_type_purpose%type);
10830:
10831: TYPE loan_tbl IS TABLE OF loan_rec INDEX BY BINARY_INTEGER;
10832:
10833: round_interest_tbl Okl_Streams_Pub.selv_tbl_type;