eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKL_PRICING_PVT dependencies on OKL_STRM_ELEMENTS

Line 35: okl_strm_elements ele,

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
38: AND chr_so.id = p_khr_id
39: AND stm.kle_id = cle_so.id

Line 36: okl_strm_elements rte

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
38: AND chr_so.id = p_khr_id
39: AND stm.kle_id = cle_so.id
40: AND cle_so.dnz_chr_id = chr_so.id

Line 96: okl_strm_elements ele,

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
99: AND chr_so.id = p_khr_id
100: AND stm.kle_id = cle_so.id

Line 97: okl_strm_elements rte

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
99: AND chr_so.id = p_khr_id
100: AND stm.kle_id = cle_so.id
101: AND cle_so.dnz_chr_id = chr_so.id

Line 205: FROM okl_strm_elements sel,

201: sel.amount se_amount,
202: sel.stream_element_date se_date,
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

Line 223: okl_strm_elements sel

219:
220: Cursor c_stub IS
221: Select sel.id
222: from okl_streams stm,
223: okl_strm_elements sel
224: where stm.khr_id = p_khr_id
225: and stm.say_code = 'HIST'
226: and stm.SGN_CODE = 'MANL'
227: and stm.active_yn = 'N'

Line 256: se_arrears okl_strm_elements.comments%type);

252: se_amount NUMBER,
253: se_date DATE,
254: se_days NUMBER,
255: se_stub VARCHAR2(1),
256: se_arrears okl_strm_elements.comments%type);
257:
258: TYPE loan_tbl IS TABLE OF loan_rec INDEX BY BINARY_INTEGER;
259:
260: asset_rents loan_tbl;

Line 1306: FROM okl_strm_elements sel,

1302: 'UNSCHEDULED_INTEREST_PAYMENT','UIP',
1303: 'DOWN_PAYMENT','DOWN_PMNT',
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

Line 1329: okl_strm_elements sel

1325: /* Commented by prasjain for bug 5474827
1326: Cursor c_stub IS
1327: Select sel.id
1328: from okl_streams stm,
1329: okl_strm_elements sel
1330: where stm.khr_id = p_khr_id
1331: and stm.say_code = 'HIST'
1332: and stm.SGN_CODE = 'MANL'
1333: and stm.active_yn = 'N'

Line 1539: FROM okl_strm_elements sel,

1535: sel.amount se_amount,
1536: sel.stream_element_date se_date,
1537: sel.comments se_arrears,
1538: sel.sel_id se_sel_id
1539: FROM okl_strm_elements sel,
1540: okl_streams stm
1541: WHERE stm.kle_id = p_kle_id
1542: AND stm.khr_id = p_khr_id
1543: AND stm.sty_id = p_sty_id

Line 2361: okl_strm_elements sel_amt,

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,
2365: okc_line_styles_b lse

Line 2362: okl_strm_elements sel_rate,

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,
2365: okc_line_styles_b lse
2366: WHERE stm.khr_id = p_khr_id

Line 2894: okl_strm_elements sel_rate,

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,
2898: okl_k_lines kle,

Line 2895: okl_strm_elements sel_amt,

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,
2898: okl_k_lines kle,
2899: okc_line_styles_b lse,

Line 2946: okl_strm_elements sel_rate,

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,
2950: okl_k_lines kle,

Line 2947: okl_strm_elements sel_amt,

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,
2950: okl_k_lines kle,
2951: okc_line_styles_b lse,

Line 2998: okl_strm_elements sel_rate,

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,
3002: okc_line_styles_b lse,

Line 2999: okl_strm_elements sel_amt,

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,
3002: okc_line_styles_b lse,
3003: okc_rules_b sll,

Line 3110: okl_strm_elements sel_amt,

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,
3114: okc_line_styles_b lse,

Line 3111: okl_strm_elements sel,

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,
3114: okc_line_styles_b lse,
3115: okl_k_lines kle,

Line 3202: miss_amt okl_strm_elements.comments%TYPE);

3198: cf_dpp NUMBER,
3199: cf_ppy NUMBER,
3200: cf_days NUMBER,
3201: rate NUMBER,
3202: miss_amt okl_strm_elements.comments%TYPE);
3203: TYPE cash_flow_tbl_type IS TABLE OF cash_flow_rec_type INDEX BY BINARY_INTEGER;
3204: hdr_inflow_tbl cash_flow_tbl_type;
3205: inflow_tbl cash_flow_tbl_type;
3206: rv_tbl cash_flow_tbl_type;

Line 4224: okl_strm_elements sel,

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
4228: WHERE stm.khr_id = p_khr_id

Line 4275: okl_strm_elements sel,

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,
4279: okc_rules_b slh,

Line 4446: okl_strm_elements sel,

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,
4450: okc_rules_b slh,

Line 5868: FROM okl_strm_elements sel,

5864: SELECT sel.id se_id,
5865: sel.amount se_amount,
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'

Line 6330: okl_strm_elements sel_rate,

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,
6334: okc_line_styles_b lse,

Line 6331: okl_strm_elements sel_amt,

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,
6334: okc_line_styles_b lse,
6335: okc_rules_b sll,

Line 6415: miss_amt okl_strm_elements.comments%TYPE);

6411: cf_dpp NUMBER,
6412: cf_ppy NUMBER,
6413: cf_days NUMBER,
6414: rate NUMBER,
6415: miss_amt okl_strm_elements.comments%TYPE);
6416:
6417: TYPE cash_flow_tbl_type IS TABLE OF cash_flow_rec_type INDEX BY BINARY_INTEGER;
6418: hdr_inflow_tbl cash_flow_tbl_type;
6419: inflow_tbl cash_flow_tbl_type;

Line 7790: okl_strm_elements ele,

7786: AND lse.lty_code = 'FREE_FORM1'
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'

Line 7803: okl_strm_elements sel

7799:
7800: Cursor c_stub IS
7801: Select sel.id
7802: from okl_streams stm,
7803: okl_strm_elements sel
7804: where stm.khr_id = p_khr_id
7805: and stm.say_code = 'HIST'
7806: and stm.SGN_CODE = 'MANL'
7807: and stm.active_yn = 'N'

Line 8159: okl_strm_elements sel,

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
8163: WHERE stm.khr_id = p_khr_id

Line 8208: okl_strm_elements sel,

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,
8212: okc_rules_b slh,

Line 8252: okl_strm_elements sel,

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,
8256: okc_rules_b sll,

Line 10793: FROM okl_strm_elements sel,

10789: sel.stream_element_date se_date,
10790: sel.comments se_arrears,
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

Line 10828: se_arrears okl_strm_elements.comments%type,

10824:
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: