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.

APPS.OKL_LA_STREAM_PVT dependencies on OKL_K_HEADERS

Line 110: p_khr_id IN okl_k_headers_full_v.id%TYPE,

106: END;
107: -- Added new procedure for get the streams for reporting and original product
108: PROCEDURE get_primary_pricing_name
109: (
110: p_khr_id IN okl_k_headers_full_v.id%TYPE,
111: p_sty_id IN okl_strm_type_b.ID%TYPE,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_primary_pricing_name OUT NOCOPY OKL_ST_GEN_TMPT_LNS.PRICING_NAME%TYPE
114: )

Line 120: FROM okl_k_headers_full_v

116: IS
117:
118: CURSOR cntrct_csr (l_khr_id NUMBER)IS
119: SELECT pdt_id, start_date
120: FROM okl_k_headers_full_v
121: WHERE id = l_khr_id;
122:
123: CURSOR pry_prc_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
124: SELECT PRICING_NAME

Line 217: p_khr_id IN okl_k_headers_full_v.id%TYPE,

213: END get_primary_pricing_name;
214:
215: PROCEDURE get_dependent_pricing_name
216: (
217: p_khr_id IN okl_k_headers_full_v.id%TYPE,
218: p_sty_id IN okl_strm_type_b.ID%TYPE,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_dependent_pricing_name OUT NOCOPY OKL_ST_GEN_TMPT_LNS.PRICING_NAME%TYPE
221: )

Line 227: FROM okl_k_headers_full_v

223: IS
224:
225: CURSOR cntrct_csr (l_khr_id NUMBER)IS
226: SELECT pdt_id, start_date
227: FROM okl_k_headers_full_v
228: WHERE id = l_khr_id;
229:
230: CURSOR pry_prc_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
231: SELECT PRICING_NAME

Line 326: p_khr_id IN okl_k_headers_full_v.id%TYPE,

322: END get_dependent_pricing_name;
323:
324: PROCEDURE get_primary_stream_type
325: (
326: p_khr_id IN okl_k_headers_full_v.id%TYPE,
327: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
328: x_return_status OUT NOCOPY VARCHAR2,
329: x_primary_sty_id OUT NOCOPY strm_rec_type
330: )

Line 336: FROM okl_k_headers_full_v

332: IS
333:
334: CURSOR cntrct_csr (l_khr_id NUMBER)IS
335: SELECT pdt_id, start_date
336: FROM okl_k_headers_full_v
337: WHERE id = l_khr_id;
338:
339: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
340: SELECT PRIMARY_STY_ID, PRICING_NAME

Line 428: p_khr_id IN okl_k_headers_full_v.id%TYPE,

424: END get_primary_stream_type;
425:
426: PROCEDURE get_primary_no_prc_stream_type
427: (
428: p_khr_id IN okl_k_headers_full_v.id%TYPE,
429: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
430: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
431: x_return_status OUT NOCOPY VARCHAR2,
432: x_primary_sty_id OUT NOCOPY strm_rec_type

Line 429: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

425:
426: PROCEDURE get_primary_no_prc_stream_type
427: (
428: p_khr_id IN okl_k_headers_full_v.id%TYPE,
429: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
430: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
431: x_return_status OUT NOCOPY VARCHAR2,
432: x_primary_sty_id OUT NOCOPY strm_rec_type
433: )

Line 441: FROM okl_k_headers_full_v

437: IS
438:
439: CURSOR cntrct_csr (l_khr_id NUMBER)IS
440: SELECT pdt_id, start_date
441: FROM okl_k_headers_full_v
442: WHERE id = l_khr_id;
443:
444: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
445: SELECT PRIMARY_STY_ID,PRICING_NAME

Line 533: p_khr_id IN okl_k_headers_full_v.id%TYPE,

529: END get_primary_no_prc_stream_type;
530:
531: PROCEDURE get_dep_no_prc_stream_type
532: (
533: p_khr_id IN okl_k_headers_full_v.id%TYPE,
534: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
535: p_primary_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
536: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
537: x_return_status OUT NOCOPY VARCHAR2,

Line 534: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

530:
531: PROCEDURE get_dep_no_prc_stream_type
532: (
533: p_khr_id IN okl_k_headers_full_v.id%TYPE,
534: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
535: p_primary_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
536: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
537: x_return_status OUT NOCOPY VARCHAR2,
538: x_dependent_sty_id OUT NOCOPY strm_rec_type

Line 545: FROM okl_k_headers_full_v

541: IS
542:
543: CURSOR cntrct_csr (l_khr_id NUMBER)IS
544: SELECT pdt_id, start_date
545: FROM okl_k_headers_full_v
546: WHERE id = l_khr_id;
547:
548: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
549: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 640: p_khr_id IN okl_k_headers_full_v.id%TYPE,

636: END get_dep_no_prc_stream_type;
637:
638: PROCEDURE get_dep_no_prc_stream_type
639: (
640: p_khr_id IN okl_k_headers_full_v.id%TYPE,
641: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
642: p_primary_sty_id IN okl_strm_type_b.id%TYPE,
643: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
644: x_return_status OUT NOCOPY VARCHAR2,

Line 641: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

637:
638: PROCEDURE get_dep_no_prc_stream_type
639: (
640: p_khr_id IN okl_k_headers_full_v.id%TYPE,
641: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
642: p_primary_sty_id IN okl_strm_type_b.id%TYPE,
643: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
644: x_return_status OUT NOCOPY VARCHAR2,
645: x_dependent_sty_id OUT NOCOPY strm_rec_type

Line 652: FROM okl_k_headers_full_v

648: IS
649:
650: CURSOR cntrct_csr (l_khr_id NUMBER)IS
651: SELECT pdt_id, start_date
652: FROM okl_k_headers_full_v
653: WHERE id = l_khr_id;
654:
655: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
656: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 747: p_khr_id IN okl_k_headers_full_v.id%TYPE,

743: END get_dep_no_prc_stream_type;
744:
745: PROCEDURE get_dep_no_prc_stream_type
746: (
747: p_khr_id IN okl_k_headers_full_v.id%TYPE,
748: p_primary_sty_id IN okl_strm_type_b.id%TYPE,
749: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
750: x_return_status OUT NOCOPY VARCHAR2,
751: x_dependent_sty_id OUT NOCOPY strm_rec_type

Line 758: FROM okl_k_headers_full_v

754: IS
755:
756: CURSOR cntrct_csr (l_khr_id NUMBER)IS
757: SELECT pdt_id, start_date
758: FROM okl_k_headers_full_v
759: WHERE id = l_khr_id;
760:
761: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
762: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 854: p_khr_id IN okl_k_headers_full_v.id%TYPE,

850:
851:
852: PROCEDURE get_primary_stream_type
853: (
854: p_khr_id IN okl_k_headers_full_v.id%TYPE,
855: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
856: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
857: x_return_status OUT NOCOPY VARCHAR2,
858: x_primary_sty_id OUT NOCOPY strm_rec_type

Line 855: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

851:
852: PROCEDURE get_primary_stream_type
853: (
854: p_khr_id IN okl_k_headers_full_v.id%TYPE,
855: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
856: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
857: x_return_status OUT NOCOPY VARCHAR2,
858: x_primary_sty_id OUT NOCOPY strm_rec_type
859: )

Line 867: FROM okl_k_headers_full_v

863: IS
864:
865: CURSOR cntrct_csr (l_khr_id NUMBER)IS
866: SELECT pdt_id, start_date
867: FROM okl_k_headers_full_v
868: WHERE id = l_khr_id;
869:
870: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
871: SELECT PRIMARY_STY_ID,PRICING_NAME

Line 960: p_khr_id IN okl_k_headers_full_v.id%TYPE,

956: END get_primary_stream_type;
957:
958: PROCEDURE get_primary_stream_types
959: (
960: p_khr_id IN okl_k_headers_full_v.id%TYPE,
961: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
962: x_return_status OUT NOCOPY VARCHAR2,
963: x_primary_sty_id OUT NOCOPY okl_strm_type_id_tbl_type
964: )

Line 970: FROM okl_k_headers_full_v

966: IS
967:
968: CURSOR cntrct_csr (l_khr_id NUMBER)IS
969: SELECT pdt_id, start_date
970: FROM okl_k_headers_full_v
971: WHERE id = l_khr_id;
972:
973: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
974: SELECT PRIMARY_STY_ID,PRICING_NAME

Line 1062: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1058: END get_primary_stream_types;
1059:
1060: PROCEDURE get_dependent_stream_type
1061: (
1062: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1063: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1064: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1065: x_return_status OUT NOCOPY VARCHAR2,
1066: x_dependent_sty_id OUT NOCOPY strm_rec_type

Line 1073: FROM okl_k_headers_full_v

1069: IS
1070:
1071: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1072: SELECT pdt_id, start_date
1073: FROM okl_k_headers_full_v
1074: WHERE id = l_khr_id;
1075:
1076: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1077: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 1166: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1162: END get_dependent_stream_type;
1163:
1164: PROCEDURE get_dependent_stream_type
1165: (
1166: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1167: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1168: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1169: x_return_status OUT NOCOPY VARCHAR2,
1170: x_dependent_sty_id OUT NOCOPY strm_rec_type

Line 1177: FROM okl_k_headers_full_v

1173: IS
1174:
1175: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1176: SELECT pdt_id, start_date
1177: FROM okl_k_headers_full_v
1178: WHERE id = l_khr_id;
1179:
1180: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1181: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 1269: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1265:
1266: END get_dependent_stream_type;
1267: PROCEDURE get_dependent_stream_types
1268: (
1269: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1270: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1271: x_return_status OUT NOCOPY VARCHAR2,
1272: x_dependent_sty_id OUT NOCOPY okl_strm_type_id_tbl_type
1273: )

Line 1279: FROM okl_k_headers_full_v

1275: IS
1276:
1277: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1278: SELECT pdt_id, start_date
1279: FROM okl_k_headers_full_v
1280: WHERE id = l_khr_id;
1281:
1282: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1283: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 1368: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1364:
1365:
1366: PROCEDURE get_dependent_stream_types
1367: (
1368: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1369: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1370: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1371: x_return_status OUT NOCOPY VARCHAR2,
1372: x_dependent_sty_id OUT NOCOPY okl_strm_type_id_tbl_type

Line 1369: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

1365:
1366: PROCEDURE get_dependent_stream_types
1367: (
1368: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1369: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1370: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1371: x_return_status OUT NOCOPY VARCHAR2,
1372: x_dependent_sty_id OUT NOCOPY okl_strm_type_id_tbl_type
1373: )

Line 1379: FROM okl_k_headers_full_v

1375: IS
1376:
1377: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1378: SELECT pdt_id, start_date
1379: FROM okl_k_headers_full_v
1380: WHERE id = l_khr_id;
1381:
1382: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1383: SELECT DEPENDENT_STY_ID, PRICING_NAME

Line 1467: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1463: END get_dependent_stream_types;
1464:
1465: PROCEDURE get_dependent_stream_type
1466: (
1467: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1468: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1469: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1470: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1471: x_return_status OUT NOCOPY VARCHAR2,

Line 1468: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

1464:
1465: PROCEDURE get_dependent_stream_type
1466: (
1467: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1468: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1469: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1470: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1471: x_return_status OUT NOCOPY VARCHAR2,
1472: x_dependent_sty_id OUT NOCOPY strm_rec_type

Line 1479: FROM okl_k_headers_full_v

1475: IS
1476:
1477: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1478: SELECT pdt_id, start_date
1479: FROM okl_k_headers_full_v
1480: WHERE id = l_khr_id;
1481:
1482: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1483: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 1575: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1571: END get_dependent_stream_type;
1572:
1573: PROCEDURE get_dependent_stream_type
1574: (
1575: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1576: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1577: p_primary_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1578: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1579: x_return_status OUT NOCOPY VARCHAR2,

Line 1576: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

1572:
1573: PROCEDURE get_dependent_stream_type
1574: (
1575: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1576: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1577: p_primary_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1578: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1579: x_return_status OUT NOCOPY VARCHAR2,
1580: x_dependent_sty_id OUT NOCOPY strm_rec_type

Line 1587: FROM okl_k_headers_full_v

1583: IS
1584:
1585: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1586: SELECT pdt_id, start_date
1587: FROM okl_k_headers_full_v
1588: WHERE id = l_khr_id;
1589:
1590: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1591: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 2122: p_contract_id IN okl_k_headers_v.id%TYPE,

2118: x_return_status OUT NOCOPY VARCHAR2,
2119: x_msg_count OUT NOCOPY NUMBER,
2120: x_msg_data OUT NOCOPY VARCHAR2,
2121: p_formula_name IN okl_formulae_v.name%TYPE,
2122: p_contract_id IN okl_k_headers_v.id%TYPE,
2123: p_line_id IN okl_k_lines_v.id%TYPE,
2124: x_value OUT NOCOPY NUMBER)
2125: IS
2126: l_api_name CONSTANT VARCHAR2(30) := 'EXECUTE_FORMULA';

Line 2645: okl_k_headers khr

2641: khr.deal_type,
2642: khr.term_duration,
2643: NVL(khr.generate_accrual_yn, 'Y')
2644: FROM okc_k_headers_b chr,
2645: okl_k_headers khr
2646: WHERE khr.id = p_chr_id
2647: AND chr.id = khr.id;
2648:
2649: --Added order by rul2.rule_information2 by djanaswa for bug 6007644

Line 2716: and pdt_id = (select pdt_id from okl_k_headers where id = p_chr_id)

2712: Cursor dependent_sty_csr (payment_type_id NUMBER, p_purpose VARCHAR2)
2713: IS
2714: Select dependent_sty_id,dependent_sty_name
2715: FROM OKL_STRM_TMPT_LINES_UV where primary_sty_id = payment_type_id
2716: and pdt_id = (select pdt_id from okl_k_headers where id = p_chr_id)
2717: and dependent_sty_purpose = p_purpose
2718: and dependent_sty_id is not null;
2719:
2720: l_dependent_strm_rec dependent_sty_csr%ROWTYPE;

Line 3947: okl_k_headers khr,

3943: chr.currency_code currency_code,
3944: khr.term_duration term,
3945: chr.orig_system_id1
3946: FROM okc_k_headers_v chr,
3947: okl_k_headers khr,
3948: okl_products_v pdt
3949: WHERE khr.id = chr.id
3950: AND chr.id = chrId
3951: AND khr.pdt_id = pdt.id(+);

Line 4271: l_stmv_rec_secure.source_table := 'OKL_K_HEADERS';

4267: --l_stmv_rec_secure.sty_id := l_styid_rec.id;
4268: l_stmv_rec_secure.sty_id := styid.id;
4269:
4270: l_stmv_rec_secure.source_id := lx_inv_agmt_chr_id_tbl(i).khr_id;
4271: l_stmv_rec_secure.source_table := 'OKL_K_HEADERS';
4272:
4273: l_selv_tbl_secure(1).amount := ln_secure_amt * -1;
4274:
4275: IF l_selv_tbl_secure(1).amount <> 0 THEN

Line 4830: l_stmv_rec_secure.source_table := 'OKL_K_HEADERS';

4826: l_stmv_rec_secure := l_stmv_rec_intm_rentals;
4827: l_selv_tbl_secure := l_selv_tbl_intm_rentals;
4828: l_stmv_rec_secure.sty_id := styid.id;
4829: l_stmv_rec_secure.source_id := lx_inv_agmt_chr_id_tbl(i).khr_id;
4830: l_stmv_rec_secure.source_table := 'OKL_K_HEADERS';
4831: l_selv_tbl_secure(1).amount := ln_secure_amt * -1;
4832: IF l_selv_tbl_secure(1).amount <> 0 THEN
4833: okl_streams_pub.create_streams(
4834: p_api_version => p_api_version,

Line 5549: okl_k_headers khr,

5545: FROM okl_subsidies_b subb,
5546: okc_k_lines_b cle_fin,
5547: okc_line_styles_b lse_fin,
5548: okc_k_lines_b cle,
5549: okl_k_headers khr,
5550: okl_k_lines kle,
5551: okc_line_styles_b lse
5552: WHERE cle.dnz_chr_id = p_dnz_chr_id
5553: AND cle.dnz_chr_id = khr.id

Line 5588: -- Sub yield record of the okl_k_headers with regular yield's

5584: FETCH validate_sub_line INTO ln_sub_exists;
5585: CLOSE validate_sub_line;
5586: --Start of modifcation BAKUCHIB
5587: -- If the contract has Subsidy line then now we are populating
5588: -- Sub yield record of the okl_k_headers with regular yield's
5589: -- given by super trump/Internal stream generation
5590: OPEN validate_esg_isg(p_dnz_chr_id => l_chr_id);
5591: FETCH validate_esg_isg INTO ln_esg_isg;
5592: CLOSE validate_esg_isg;

Line 6444: FROM OKL_K_HEADERS KHR

6440: -- Cursor to get Terminated Asset lines of a LOAN contract
6441: CURSOR c_tmt_asset_loan (cp_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
6442: SELECT CLE.ID LINE_ID
6443: , CLE.DATE_TERMINATED
6444: FROM OKL_K_HEADERS KHR
6445: , OKC_K_LINES_B CLE
6446: , OKC_LINE_STYLES_B LSE
6447: , OKC_STATUSES_B STS
6448: WHERE CLE.DNZ_CHR_ID = KHR.ID

Line 6647: FROM okl_k_headers

6643:
6644: --To get the regular product id
6645: CURSOR c_get_regular_product_id IS
6646: SELECT pdt_id
6647: FROM okl_k_headers
6648: WHERE id = p_chr_id;
6649:
6650: --To get the reporting product id
6651: CURSOR c_get_report_product_id IS

Line 6653: FROM okl_k_headers khr,

6649:
6650: --To get the reporting product id
6651: CURSOR c_get_report_product_id IS
6652: SELECT pdt.reporting_pdt_id
6653: FROM okl_k_headers khr,
6654: okl_products pdt
6655: WHERE khr.id = p_chr_id
6656: AND khr.pdt_id = pdt.id;
6657:

Line 7109: from okl_k_headers_full_v

7105:
7106:
7107: Cursor ylds_csr( chrId NUMBER ) IS
7108: Select 'N' exist
7109: from okl_k_headers_full_v
7110: where id = chrId
7111: and pre_tax_yield is NULL
7112: and after_tax_yield is NULL
7113: and pre_tax_irr is NULL

Line 7171: FROM okl_k_headers khr,

7167: IS
7168: SELECT 'Y'
7169: FROM DUAL
7170: WHERE EXISTS (SELECT 1
7171: FROM okl_k_headers khr,
7172: okl_products_v pdt
7173: WHERE khr.id = p_chr_id
7174: AND khr.pdt_id = pdt.id
7175: AND pdt.reporting_pdt_id IS NOT NULL);

Line 8213: FROM OKL_K_HEADERS

8209:
8210: -- srsreeni - Bug#5699923 - Added - Start
8211: CURSOR c_is_loan_khr(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
8212: SELECT 'Y'
8213: FROM OKL_K_HEADERS
8214: WHERE ID = p_chr_id
8215: AND DEAL_TYPE = 'LOAN';
8216:
8217: l_is_loan_khr VARCHAR2(1) := 'N';

Line 9583: okl_k_headers khr,

9579: IS
9580: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
9581: gts.days_in_yr_code
9582: FROM
9583: okl_k_headers khr,
9584: okl_products_v pdt,
9585: okl_ae_tmpt_sets_v aes,
9586: OKL_ST_GEN_TMPT_SETS gts
9587: WHERE

Line 11959: okl_k_headers khr,

11955: IS
11956: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
11957: gts.days_in_yr_code
11958: FROM
11959: okl_k_headers khr,
11960: okl_products_v pdt,
11961: okl_ae_tmpt_sets_v aes,
11962: OKL_ST_GEN_TMPT_SETS gts
11963: WHERE

Line 13143: okl_k_headers khr,

13139: Cursor check_fixed_contract(chrId VARCHAR2) is
13140: SELECT
13141: gts.interest_calc_meth_code
13142: FROM
13143: okl_k_headers khr,
13144: okl_products_v pdt,
13145: okl_ae_tmpt_sets_v aes,
13146: OKL_ST_GEN_TMPT_SETS gts
13147: WHERE

Line 13157: okl_k_headers

13153: Cursor get_iir_value(chrId VARCHAR2) is
13154: SELECT
13155: implicit_interest_rate
13156: FROM
13157: okl_k_headers
13158: WHERE id=chrId;
13159: --Bug 5146545 dpsingh end
13160:
13161:

Line 13214: okl_k_headers khr,

13210: IS
13211: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
13212: gts.days_in_yr_code
13213: FROM
13214: okl_k_headers khr,
13215: okl_products_v pdt,
13216: okl_ae_tmpt_sets_v aes,
13217: OKL_ST_GEN_TMPT_SETS gts
13218: WHERE

Line 15289: okl_k_headers khr,

15285: IS
15286: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
15287: gts.days_in_yr_code
15288: FROM
15289: okl_k_headers khr,
15290: okl_products_v pdt,
15291: okl_ae_tmpt_sets_v aes,
15292: OKL_ST_GEN_TMPT_SETS gts
15293: WHERE

Line 17552: okl_k_headers khr,

17548: NVL(pdt.reporting_pdt_id, -1) report_pdt_id,
17549: chr.currency_code currency_code,
17550: khr.term_duration term
17551: FROM okc_k_headers_v chr,
17552: okl_k_headers khr,
17553: okl_products_v pdt
17554: WHERE khr.id = chr.id
17555: AND chr.id = chrId
17556: AND khr.pdt_id = pdt.id(+);

Line 17763: okl_k_headers khr,

17759: IS
17760: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
17761: gts.days_in_yr_code
17762: FROM
17763: okl_k_headers khr,
17764: okl_products_v pdt,
17765: okl_ae_tmpt_sets_v aes,
17766: OKL_ST_GEN_TMPT_SETS gts
17767: WHERE

Line 20805: CURSOR c_get_psth_csr(p_khr_id okl_k_headers.id%TYPE)

20801: ln_cnt_rte_not_null NUMBER := 0;
20802: ln_tot_cnt NUMBER := 0;
20803: l_freq VARCHAR2(1);
20804: -- Get Passthrough Fee Lines
20805: CURSOR c_get_psth_csr(p_khr_id okl_k_headers.id%TYPE)
20806: IS
20807: SELECT cle.id
20808: FROM okc_k_lines_b cle,
20809: okl_k_lines kle,

Line 20818: CURSOR c_get_pay_psth_csr(p_khr_id okl_k_headers.id%TYPE,

20814: AND lse.lty_code = 'FEE'
20815: AND cle.id = kle.id
20816: AND kle.fee_type = G_FEE_TYPE;
20817: -- Get number of SLH payments for Passthrough fee type
20818: CURSOR c_get_pay_psth_csr(p_khr_id okl_k_headers.id%TYPE,
20819: p_kle_id okl_k_headers.id%TYPE)
20820: IS
20821: SELECT COUNT(*)
20822: FROM okc_rules_b slh,

Line 20819: p_kle_id okl_k_headers.id%TYPE)

20815: AND cle.id = kle.id
20816: AND kle.fee_type = G_FEE_TYPE;
20817: -- Get number of SLH payments for Passthrough fee type
20818: CURSOR c_get_pay_psth_csr(p_khr_id okl_k_headers.id%TYPE,
20819: p_kle_id okl_k_headers.id%TYPE)
20820: IS
20821: SELECT COUNT(*)
20822: FROM okc_rules_b slh,
20823: okc_rule_groups_b rgp,

Line 20834: CURSOR c_get_all_lines_csr(p_khr_id okl_k_headers.id%TYPE)

20830: AND kle.fee_type = G_FEE_TYPE
20831: AND slh.rule_information_category = G_RUL_SLH_CODE;
20832:
20833: -- Get all the Top lines for p_khr_id
20834: CURSOR c_get_all_lines_csr(p_khr_id okl_k_headers.id%TYPE)
20835: IS
20836: SELECT cle.id line_id
20837: FROM okc_k_lines_b cle,
20838: okc_line_styles_b lse

Line 20845: CURSOR c_get_slh_lines_csr(p_khr_id okl_k_headers.id%TYPE,

20841: AND cle.sts_code NOT IN ('HOLD', 'EXPIRED', 'CANCELLED')
20842: AND lse.lty_code IN ('FREE_FORM1','FEE','SOLD_SERVICE');
20843:
20844: -- Get all the SLH payment lines for Each Khr_id and Line Id
20845: CURSOR c_get_slh_lines_csr(p_khr_id okl_k_headers.id%TYPE,
20846: p_cle_id okl_k_lines.id%TYPE)
20847: IS
20848: SELECT rul.id slh_id
20849: FROM okc_rule_groups_b rgp,

Line 20858: CURSOR c_get_sll_lines_csr(p_khr_id okl_k_headers.id%TYPE,

20854: AND rgp.dnz_chr_id = p_khr_id
20855: AND rgp.cle_id = p_cle_id;
20856:
20857: -- Get all the SLL payment lines for Each Khr_id,SLH id and Line Id
20858: CURSOR c_get_sll_lines_csr(p_khr_id okl_k_headers.id%TYPE,
20859: p_cle_id okl_k_lines.id%TYPE,
20860: p_slh_id okc_rules_b.id%TYPE)
20861: IS
20862: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,

Line 21886: okl_k_headers khr,

21882: NVL(pdt.reporting_pdt_id, -1) report_pdt_id,
21883: chr.currency_code currency_code,
21884: khr.term_duration term
21885: FROM okc_k_headers_v chr,
21886: okl_k_headers khr,
21887: okl_products_v pdt
21888: WHERE khr.id = chr.id
21889: AND chr.id = chrId
21890: AND khr.pdt_id = pdt.id(+);

Line 22243: okl_k_headers khr,

22239: IS
22240: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
22241: gts.days_in_yr_code
22242: FROM
22243: okl_k_headers khr,
22244: okl_products_v pdt,
22245: okl_ae_tmpt_sets_v aes,
22246: OKL_ST_GEN_TMPT_SETS gts
22247: WHERE