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 109: p_khr_id IN okl_k_headers_full_v.id%TYPE,

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

Line 119: FROM okl_k_headers_full_v

115: IS
116:
117: CURSOR cntrct_csr (l_khr_id NUMBER)IS
118: SELECT pdt_id, start_date
119: FROM okl_k_headers_full_v
120: WHERE id = l_khr_id;
121:
122: CURSOR pry_prc_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
123: 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 327: p_khr_id IN okl_k_headers_full_v.id%TYPE,

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

Line 337: FROM okl_k_headers_full_v

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

Line 429: p_khr_id IN okl_k_headers_full_v.id%TYPE,

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

Line 430: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

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

Line 442: FROM okl_k_headers_full_v

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

Line 534: p_khr_id IN okl_k_headers_full_v.id%TYPE,

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

Line 535: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

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

Line 546: FROM okl_k_headers_full_v

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

Line 638: p_khr_id IN okl_k_headers_full_v.id%TYPE,

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

Line 639: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

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

Line 650: FROM okl_k_headers_full_v

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

Line 740: p_khr_id IN okl_k_headers_full_v.id%TYPE,

736: END get_dep_no_prc_stream_type;
737:
738: PROCEDURE get_dep_no_prc_stream_type
739: (
740: p_khr_id IN okl_k_headers_full_v.id%TYPE,
741: p_primary_sty_id IN okl_strm_type_b.id%TYPE,
742: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
743: x_return_status OUT NOCOPY VARCHAR2,
744: x_dependent_sty_id OUT NOCOPY strm_rec_type

Line 751: FROM okl_k_headers_full_v

747: IS
748:
749: CURSOR cntrct_csr (l_khr_id NUMBER)IS
750: SELECT pdt_id, start_date
751: FROM okl_k_headers_full_v
752: WHERE id = l_khr_id;
753:
754: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
755: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 842: p_khr_id IN okl_k_headers_full_v.id%TYPE,

838:
839:
840: PROCEDURE get_primary_stream_type
841: (
842: p_khr_id IN okl_k_headers_full_v.id%TYPE,
843: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
844: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
845: x_return_status OUT NOCOPY VARCHAR2,
846: x_primary_sty_id OUT NOCOPY strm_rec_type

Line 843: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

839:
840: PROCEDURE get_primary_stream_type
841: (
842: p_khr_id IN okl_k_headers_full_v.id%TYPE,
843: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
844: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
845: x_return_status OUT NOCOPY VARCHAR2,
846: x_primary_sty_id OUT NOCOPY strm_rec_type
847: )

Line 855: FROM okl_k_headers_full_v

851: IS
852:
853: CURSOR cntrct_csr (l_khr_id NUMBER)IS
854: SELECT pdt_id, start_date
855: FROM okl_k_headers_full_v
856: WHERE id = l_khr_id;
857:
858: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
859: SELECT PRIMARY_STY_ID,PRICING_NAME

Line 954: p_khr_id IN okl_k_headers_full_v.id%TYPE,

950: END get_primary_stream_type;
951:
952: PROCEDURE get_primary_stream_types
953: (
954: p_khr_id IN okl_k_headers_full_v.id%TYPE,
955: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
956: x_return_status OUT NOCOPY VARCHAR2,
957: x_primary_sty_id OUT NOCOPY okl_strm_type_id_tbl_type
958: )

Line 964: FROM okl_k_headers_full_v

960: IS
961:
962: CURSOR cntrct_csr (l_khr_id NUMBER)IS
963: SELECT pdt_id, start_date
964: FROM okl_k_headers_full_v
965: WHERE id = l_khr_id;
966:
967: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
968: SELECT PRIMARY_STY_ID,PRICING_NAME

Line 1056: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1052: END get_primary_stream_types;
1053:
1054: PROCEDURE get_dependent_stream_type
1055: (
1056: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1057: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1058: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1059: x_return_status OUT NOCOPY VARCHAR2,
1060: x_dependent_sty_id OUT NOCOPY strm_rec_type

Line 1067: FROM okl_k_headers_full_v

1063: IS
1064:
1065: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1066: SELECT pdt_id, start_date
1067: FROM okl_k_headers_full_v
1068: WHERE id = l_khr_id;
1069:
1070: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1071: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 1155: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1151: END get_dependent_stream_type;
1152:
1153: PROCEDURE get_dependent_stream_type
1154: (
1155: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1156: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1157: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1158: x_return_status OUT NOCOPY VARCHAR2,
1159: x_dependent_sty_id OUT NOCOPY strm_rec_type

Line 1166: FROM okl_k_headers_full_v

1162: IS
1163:
1164: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1165: SELECT pdt_id, start_date
1166: FROM okl_k_headers_full_v
1167: WHERE id = l_khr_id;
1168:
1169: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1170: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 1253: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1249:
1250: END get_dependent_stream_type;
1251: PROCEDURE get_dependent_stream_types
1252: (
1253: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1254: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1255: x_return_status OUT NOCOPY VARCHAR2,
1256: x_dependent_sty_id OUT NOCOPY okl_strm_type_id_tbl_type
1257: )

Line 1263: FROM okl_k_headers_full_v

1259: IS
1260:
1261: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1262: SELECT pdt_id, start_date
1263: FROM okl_k_headers_full_v
1264: WHERE id = l_khr_id;
1265:
1266: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1267: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 1347: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1343:
1344:
1345: PROCEDURE get_dependent_stream_types
1346: (
1347: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1348: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1349: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1350: x_return_status OUT NOCOPY VARCHAR2,
1351: x_dependent_sty_id OUT NOCOPY okl_strm_type_id_tbl_type

Line 1348: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

1344:
1345: PROCEDURE get_dependent_stream_types
1346: (
1347: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1348: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1349: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1350: x_return_status OUT NOCOPY VARCHAR2,
1351: x_dependent_sty_id OUT NOCOPY okl_strm_type_id_tbl_type
1352: )

Line 1358: FROM okl_k_headers_full_v

1354: IS
1355:
1356: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1357: SELECT pdt_id, start_date
1358: FROM okl_k_headers_full_v
1359: WHERE id = l_khr_id;
1360:
1361: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1362: SELECT DEPENDENT_STY_ID, PRICING_NAME

Line 1441: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1437: END get_dependent_stream_types;
1438:
1439: PROCEDURE get_dependent_stream_type
1440: (
1441: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1442: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1443: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1444: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1445: x_return_status OUT NOCOPY VARCHAR2,

Line 1442: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

1438:
1439: PROCEDURE get_dependent_stream_type
1440: (
1441: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1442: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1443: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1444: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1445: x_return_status OUT NOCOPY VARCHAR2,
1446: x_dependent_sty_id OUT NOCOPY strm_rec_type

Line 1453: FROM okl_k_headers_full_v

1449: IS
1450:
1451: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1452: SELECT pdt_id, start_date
1453: FROM okl_k_headers_full_v
1454: WHERE id = l_khr_id;
1455:
1456: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1457: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 1551: p_khr_id IN okl_k_headers_full_v.id%TYPE,

1547: END get_dependent_stream_type;
1548:
1549: PROCEDURE get_dependent_stream_type
1550: (
1551: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1552: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1553: p_primary_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1554: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1555: x_return_status OUT NOCOPY VARCHAR2,

Line 1552: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,

1548:
1549: PROCEDURE get_dependent_stream_type
1550: (
1551: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1552: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1553: p_primary_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1554: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1555: x_return_status OUT NOCOPY VARCHAR2,
1556: x_dependent_sty_id OUT NOCOPY strm_rec_type

Line 1563: FROM okl_k_headers_full_v

1559: IS
1560:
1561: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1562: SELECT pdt_id, start_date
1563: FROM okl_k_headers_full_v
1564: WHERE id = l_khr_id;
1565:
1566: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1567: SELECT DEPENDENT_STY_ID,PRICING_NAME

Line 2101: p_contract_id IN okl_k_headers_v.id%TYPE,

2097: x_return_status OUT NOCOPY VARCHAR2,
2098: x_msg_count OUT NOCOPY NUMBER,
2099: x_msg_data OUT NOCOPY VARCHAR2,
2100: p_formula_name IN okl_formulae_v.name%TYPE,
2101: p_contract_id IN okl_k_headers_v.id%TYPE,
2102: p_line_id IN okl_k_lines_v.id%TYPE,
2103: x_value OUT NOCOPY NUMBER)
2104: IS
2105: l_api_name CONSTANT VARCHAR2(30) := 'EXECUTE_FORMULA';

Line 3061: okl_k_headers khr

3057: khr.deal_type,
3058: khr.term_duration,
3059: NVL(khr.generate_accrual_yn, 'Y')
3060: FROM okc_k_headers_b chr,
3061: okl_k_headers khr
3062: WHERE khr.id = p_chr_id
3063: AND chr.id = khr.id;
3064:
3065: --Added order by rul2.rule_information2 by djanaswa for bug 6007644

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

3128: Cursor dependent_sty_csr (payment_type_id NUMBER, p_purpose VARCHAR2)
3129: IS
3130: Select dependent_sty_id,dependent_sty_name
3131: FROM OKL_STRM_TMPT_LINES_UV where primary_sty_id = payment_type_id
3132: and pdt_id = (select pdt_id from okl_k_headers where id = p_chr_id)
3133: and dependent_sty_purpose = p_purpose
3134: and dependent_sty_id is not null;
3135:
3136: l_dependent_strm_rec dependent_sty_csr%ROWTYPE;

Line 5046: okl_k_headers khr,

5042: chr.currency_code currency_code,
5043: khr.term_duration term,
5044: chr.orig_system_id1
5045: FROM okc_k_headers_v chr,
5046: okl_k_headers khr,
5047: okl_products_v pdt
5048: WHERE khr.id = chr.id
5049: AND chr.id = chrId
5050: AND khr.pdt_id = pdt.id(+);

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

5366: --l_stmv_rec_secure.sty_id := l_styid_rec.id;
5367: l_stmv_rec_secure.sty_id := styid.id;
5368:
5369: l_stmv_rec_secure.source_id := lx_inv_agmt_chr_id_tbl(i).khr_id;
5370: l_stmv_rec_secure.source_table := 'OKL_K_HEADERS';
5371:
5372: l_selv_tbl_secure(1).amount := ln_secure_amt * -1;
5373:
5374: IF l_selv_tbl_secure(1).amount <> 0 THEN

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

5925: l_stmv_rec_secure := l_stmv_rec_intm_rentals;
5926: l_selv_tbl_secure := l_selv_tbl_intm_rentals;
5927: l_stmv_rec_secure.sty_id := styid.id;
5928: l_stmv_rec_secure.source_id := lx_inv_agmt_chr_id_tbl(i).khr_id;
5929: l_stmv_rec_secure.source_table := 'OKL_K_HEADERS';
5930: l_selv_tbl_secure(1).amount := ln_secure_amt * -1;
5931: IF l_selv_tbl_secure(1).amount <> 0 THEN
5932: okl_streams_pub.create_streams(
5933: p_api_version => p_api_version,

Line 6659: okl_k_headers khr,

6655: FROM okl_subsidies_b subb,
6656: okc_k_lines_b cle_fin,
6657: okc_line_styles_b lse_fin,
6658: okc_k_lines_b cle,
6659: okl_k_headers khr,
6660: okl_k_lines kle,
6661: okc_line_styles_b lse
6662: WHERE cle.dnz_chr_id = p_dnz_chr_id
6663: AND cle.dnz_chr_id = khr.id

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

6694: FETCH validate_sub_line INTO ln_sub_exists;
6695: CLOSE validate_sub_line;
6696: --Start of modifcation BAKUCHIB
6697: -- If the contract has Subsidy line then now we are populating
6698: -- Sub yield record of the okl_k_headers with regular yield's
6699: -- given by super trump/Internal stream generation
6700: OPEN validate_esg_isg(p_dnz_chr_id => l_chr_id);
6701: FETCH validate_esg_isg INTO ln_esg_isg;
6702: CLOSE validate_esg_isg;

Line 6851: FROM OKL_K_HEADERS KHR

6847: --Cursor to get the terminated assets
6848: CURSOR c_tmt_assets (cp_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
6849: SELECT CLE.ID LINE_ID
6850: , TRUNC(CLE.DATE_TERMINATED) TERMINATION_DATE
6851: FROM OKL_K_HEADERS KHR
6852: , OKC_K_LINES_B CLE
6853: , OKC_LINE_STYLES_B LSE
6854: , OKC_STATUSES_B STS
6855: WHERE CLE.DNZ_CHR_ID = KHR.ID

Line 7018: FROM OKL_K_HEADERS KHR

7014:
7015: --Cursor to get the terminated assets
7016: CURSOR c_tmt_assets (cp_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
7017: SELECT CLE.ID LINE_ID
7018: FROM OKL_K_HEADERS KHR
7019: , OKC_K_LINES_B CLE
7020: , OKC_LINE_STYLES_B LSE
7021: , OKC_STATUSES_B STS
7022: WHERE CLE.DNZ_CHR_ID = KHR.ID

Line 7881: FROM OKL_K_HEADERS KHR

7877: -- Cursor to get Terminated Asset lines of a LOAN contract
7878: CURSOR c_tmt_asset_loan (cp_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
7879: SELECT CLE.ID LINE_ID
7880: , CLE.DATE_TERMINATED
7881: FROM OKL_K_HEADERS KHR
7882: , OKC_K_LINES_B CLE
7883: , OKC_LINE_STYLES_B LSE
7884: , OKC_STATUSES_B STS
7885: WHERE CLE.DNZ_CHR_ID = KHR.ID

Line 8085: FROM okl_k_headers

8081:
8082: --To get the regular product id
8083: CURSOR c_get_regular_product_id IS
8084: SELECT pdt_id
8085: FROM okl_k_headers
8086: WHERE id = p_chr_id;
8087:
8088: --To get the reporting product id
8089: CURSOR c_get_report_product_id IS

Line 8091: FROM okl_k_headers khr,

8087:
8088: --To get the reporting product id
8089: CURSOR c_get_report_product_id IS
8090: SELECT pdt.reporting_pdt_id
8091: FROM okl_k_headers khr,
8092: okl_products pdt
8093: WHERE khr.id = p_chr_id
8094: AND khr.pdt_id = pdt.id;
8095:

Line 8603: from okl_k_headers_full_v

8599:
8600:
8601: Cursor ylds_csr( chrId NUMBER ) IS
8602: Select 'N' exist
8603: from okl_k_headers_full_v
8604: where id = chrId
8605: and pre_tax_yield is NULL
8606: and after_tax_yield is NULL
8607: and pre_tax_irr is NULL

Line 8665: FROM okl_k_headers khr,

8661: IS
8662: SELECT 'Y'
8663: FROM DUAL
8664: WHERE EXISTS (SELECT 1
8665: FROM okl_k_headers khr,
8666: okl_products_v pdt
8667: WHERE khr.id = p_chr_id
8668: AND khr.pdt_id = pdt.id
8669: AND pdt.reporting_pdt_id IS NOT NULL);

Line 9733: FROM OKL_K_HEADERS

9729:
9730: -- srsreeni - Bug#5699923 - Added - Start
9731: CURSOR c_is_loan_khr(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
9732: SELECT 'Y'
9733: FROM OKL_K_HEADERS
9734: WHERE ID = p_chr_id
9735: AND DEAL_TYPE = 'LOAN';
9736:
9737: l_is_loan_khr VARCHAR2(1) := 'N';

Line 11171: okl_k_headers khr,

11167: IS
11168: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
11169: gts.days_in_yr_code
11170: FROM
11171: okl_k_headers khr,
11172: okl_products_v pdt,
11173: okl_ae_tmpt_sets_v aes,
11174: OKL_ST_GEN_TMPT_SETS gts
11175: WHERE

Line 13889: okl_k_headers khr,

13885: IS
13886: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
13887: gts.days_in_yr_code
13888: FROM
13889: okl_k_headers khr,
13890: okl_products_v pdt,
13891: okl_ae_tmpt_sets_v aes,
13892: OKL_ST_GEN_TMPT_SETS gts
13893: WHERE

Line 15246: okl_k_headers khr,

15242: Cursor check_fixed_contract(chrId VARCHAR2) is
15243: SELECT
15244: gts.interest_calc_meth_code
15245: FROM
15246: okl_k_headers khr,
15247: okl_products_v pdt,
15248: okl_ae_tmpt_sets_v aes,
15249: OKL_ST_GEN_TMPT_SETS gts
15250: WHERE

Line 15260: okl_k_headers

15256: Cursor get_iir_value(chrId VARCHAR2) is
15257: SELECT
15258: implicit_interest_rate
15259: FROM
15260: okl_k_headers
15261: WHERE id=chrId;
15262: --Bug 5146545 dpsingh end
15263:
15264:

Line 15317: okl_k_headers khr,

15313: IS
15314: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
15315: gts.days_in_yr_code
15316: FROM
15317: okl_k_headers khr,
15318: okl_products_v pdt,
15319: okl_ae_tmpt_sets_v aes,
15320: OKL_ST_GEN_TMPT_SETS gts
15321: WHERE

Line 17602: okl_k_headers khr,

17598: IS
17599: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
17600: gts.days_in_yr_code
17601: FROM
17602: okl_k_headers khr,
17603: okl_products_v pdt,
17604: okl_ae_tmpt_sets_v aes,
17605: OKL_ST_GEN_TMPT_SETS gts
17606: WHERE

Line 20186: okl_k_headers khr,

20182: NVL(pdt.reporting_pdt_id, -1) report_pdt_id,
20183: chr.currency_code currency_code,
20184: khr.term_duration term
20185: FROM okc_k_headers_v chr,
20186: okl_k_headers khr,
20187: okl_products_v pdt
20188: WHERE khr.id = chr.id
20189: AND chr.id = chrId
20190: AND khr.pdt_id = pdt.id(+);

Line 20401: okl_k_headers khr,

20397: IS
20398: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
20399: gts.days_in_yr_code
20400: FROM
20401: okl_k_headers khr,
20402: okl_products_v pdt,
20403: okl_ae_tmpt_sets_v aes,
20404: OKL_ST_GEN_TMPT_SETS gts
20405: WHERE

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

23637: ln_cnt_rte_not_null NUMBER := 0;
23638: ln_tot_cnt NUMBER := 0;
23639: l_freq VARCHAR2(1);
23640: -- Get Passthrough Fee Lines
23641: CURSOR c_get_psth_csr(p_khr_id okl_k_headers.id%TYPE)
23642: IS
23643: SELECT cle.id
23644: FROM okc_k_lines_b cle,
23645: okl_k_lines kle,

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

23650: AND lse.lty_code = 'FEE'
23651: AND cle.id = kle.id
23652: AND kle.fee_type = G_FEE_TYPE;
23653: -- Get number of SLH payments for Passthrough fee type
23654: CURSOR c_get_pay_psth_csr(p_khr_id okl_k_headers.id%TYPE,
23655: p_kle_id okl_k_headers.id%TYPE)
23656: IS
23657: SELECT COUNT(*)
23658: FROM okc_rules_b slh,

Line 23655: p_kle_id okl_k_headers.id%TYPE)

23651: AND cle.id = kle.id
23652: AND kle.fee_type = G_FEE_TYPE;
23653: -- Get number of SLH payments for Passthrough fee type
23654: CURSOR c_get_pay_psth_csr(p_khr_id okl_k_headers.id%TYPE,
23655: p_kle_id okl_k_headers.id%TYPE)
23656: IS
23657: SELECT COUNT(*)
23658: FROM okc_rules_b slh,
23659: okc_rule_groups_b rgp,

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

23666: AND kle.fee_type = G_FEE_TYPE
23667: AND slh.rule_information_category = G_RUL_SLH_CODE;
23668:
23669: -- Get all the Top lines for p_khr_id
23670: CURSOR c_get_all_lines_csr(p_khr_id okl_k_headers.id%TYPE)
23671: IS
23672: SELECT cle.id line_id
23673: FROM okc_k_lines_b cle,
23674: okc_line_styles_b lse

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

23677: AND cle.sts_code NOT IN ('HOLD', 'EXPIRED', 'CANCELLED')
23678: AND lse.lty_code IN ('FREE_FORM1','FEE','SOLD_SERVICE');
23679:
23680: -- Get all the SLH payment lines for Each Khr_id and Line Id
23681: CURSOR c_get_slh_lines_csr(p_khr_id okl_k_headers.id%TYPE,
23682: p_cle_id okl_k_lines.id%TYPE)
23683: IS
23684: SELECT rul.id slh_id
23685: FROM okc_rule_groups_b rgp,

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

23690: AND rgp.dnz_chr_id = p_khr_id
23691: AND rgp.cle_id = p_cle_id;
23692:
23693: -- Get all the SLL payment lines for Each Khr_id,SLH id and Line Id
23694: CURSOR c_get_sll_lines_csr(p_khr_id okl_k_headers.id%TYPE,
23695: p_cle_id okl_k_lines.id%TYPE,
23696: p_slh_id okc_rules_b.id%TYPE)
23697: IS
23698: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,

Line 24729: okl_k_headers khr,

24725: NVL(pdt.reporting_pdt_id, -1) report_pdt_id,
24726: chr.currency_code currency_code,
24727: khr.term_duration term
24728: FROM okc_k_headers_v chr,
24729: okl_k_headers khr,
24730: okl_products_v pdt
24731: WHERE khr.id = chr.id
24732: AND chr.id = chrId
24733: AND khr.pdt_id = pdt.id(+);

Line 25086: okl_k_headers khr,

25082: IS
25083: SELECT DECODE(gts.days_in_month_code,'30','360',gts.days_in_month_code) days_in_month_code,
25084: gts.days_in_yr_code
25085: FROM
25086: okl_k_headers khr,
25087: okl_products_v pdt,
25088: okl_ae_tmpt_sets_v aes,
25089: OKL_ST_GEN_TMPT_SETS gts
25090: WHERE