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_STREAM_GENERATOR_PVT dependencies on OKL_K_HEADERS

Line 42: okl_k_headers khr,

38: nvl(pdt.reporting_pdt_id, -1) report_pdt_id,
39: chr.currency_code currency_code,
40: khr.term_duration term
41: from okc_k_headers_v chr,
42: okl_k_headers khr,
43: okl_products_v pdt
44: where khr.id = chr.id
45: and chr.id = p_khr_id
46: and khr.pdt_id = pdt.id(+);

Line 846: okl_k_headers khr

842: khr.deal_type,
843: khr.term_duration,
844: NVL(khr.generate_accrual_yn, 'Y')
845: FROM okc_k_headers_b chr,
846: okl_k_headers khr
847: WHERE khr.id = p_khr_id
848: AND chr.id = khr.id;
849:
850: l_hdr c_hdr%ROWTYPE;

Line 2015: okl_k_headers khr,

2011: nvl(pdt.reporting_pdt_id, -1) report_pdt_id,
2012: chr.currency_code currency_code,
2013: khr.term_duration term
2014: from okc_k_headers_v chr,
2015: okl_k_headers khr,
2016: okl_products_v pdt
2017: where khr.id = chr.id
2018: and chr.id = p_khr_id
2019: and khr.pdt_id = pdt.id(+);

Line 4048: okl_k_headers khr

4044: khr.term_duration,
4045: khr.pre_tax_irr,
4046: NVL(khr.generate_accrual_yn, 'Y')
4047: FROM okc_k_headers_b chr,
4048: okl_k_headers khr
4049: WHERE khr.id = p_khr_id
4050: AND chr.id = khr.id;
4051:
4052: cursor l_line_csr( chrid NUMBER, lnetype VARCHAR2 ) is

Line 4912: okl_k_headers khr

4908: khr.deal_type,
4909: khr.term_duration,
4910: NVL(khr.generate_accrual_yn, 'Y')
4911: FROM okc_k_headers_b chr,
4912: okl_k_headers khr
4913: WHERE khr.id = p_khr_id
4914: AND chr.id = khr.id;
4915:
4916: l_hdr c_hdr%ROWTYPE;

Line 5303: okl_k_headers khr

5299: khr.deal_type,
5300: khr.term_duration,
5301: NVL(khr.generate_accrual_yn, 'Y')
5302: FROM okc_k_headers_b chr,
5303: okl_k_headers khr
5304: WHERE khr.id = p_khr_id
5305: AND chr.id = khr.id;
5306:
5307: l_hdr c_hdr%ROWTYPE;

Line 5995: okl_k_headers khr,

5991: khr.term_duration,
5992: NVL(khr.generate_accrual_yn, 'Y'),
5993: nvl(rpar.base_rate, 10) base_rate
5994: FROM okc_k_headers_b chr,
5995: okl_k_headers khr,
5996: OKL_K_RATE_PARAMS rpar
5997: WHERE khr.id = p_khr_id
5998: AND chr.id = khr.id
5999: AND rpar.khr_id(+) = khr.id;

Line 7939: okl_k_headers khr

7935: khr.deal_type,
7936: khr.term_duration,
7937: NVL(khr.generate_accrual_yn, 'Y')
7938: FROM okc_k_headers_b chr,
7939: okl_k_headers khr
7940: WHERE khr.id = p_khr_id
7941: AND chr.id = khr.id;
7942:
7943: l_hdr c_hdr%ROWTYPE;

Line 8227: okl_K_headers_full_v pkhr,

8223: nvl(pkhr.after_tax_yield, -1) agmnt_yield,
8224: nvl(khr.PRE_TAX_IRR, -1) contract_yield
8225: from okl_pools pol,
8226: okl_pool_contents pcn,
8227: okl_K_headers_full_v pkhr,
8228: okl_k_headers khr
8229: where pcn.pol_id = pol.id
8230: and pcn.khr_id = khr.id
8231: and pol.khr_id = pkhr.id

Line 8228: okl_k_headers khr

8224: nvl(khr.PRE_TAX_IRR, -1) contract_yield
8225: from okl_pools pol,
8226: okl_pool_contents pcn,
8227: okl_K_headers_full_v pkhr,
8228: okl_k_headers khr
8229: where pcn.pol_id = pol.id
8230: and pcn.khr_id = khr.id
8231: and pol.khr_id = pkhr.id
8232: and pol.khr_id = agmntID

Line 8286: okl_K_headers_full_v pkhr,

8282: nvl(pkhr.after_tax_yield, -1) agmnt_yield,
8283: nvl(khr.PRE_TAX_IRR, -1) contract_yield
8284: from okl_pools pol,
8285: okl_pool_contents pcn,
8286: okl_K_headers_full_v pkhr,
8287: okl_k_headers khr
8288: where pcn.pol_id = pol.id
8289: and pcn.khr_id = khr.id
8290: and pol.khr_id = pkhr.id

Line 8287: okl_k_headers khr

8283: nvl(khr.PRE_TAX_IRR, -1) contract_yield
8284: from okl_pools pol,
8285: okl_pool_contents pcn,
8286: okl_K_headers_full_v pkhr,
8287: okl_k_headers khr
8288: where pcn.pol_id = pol.id
8289: and pcn.khr_id = khr.id
8290: and pol.khr_id = pkhr.id
8291: and pol.khr_id = agmntID

Line 8896: okl_K_headers_full_v pkhr,

8892: pkhr.contract_number agreement_number,
8893: nvl(khr.PRE_TAX_IRR, -1) contract_yield
8894: from okl_pools pol,
8895: okl_pool_contents pcn,
8896: okl_K_headers_full_v pkhr,
8897: okl_k_headers khr
8898: where pcn.pol_id = pol.id
8899: and pcn.khr_id = khr.id
8900: and pol.khr_id = pkhr.id

Line 8897: okl_k_headers khr

8893: nvl(khr.PRE_TAX_IRR, -1) contract_yield
8894: from okl_pools pol,
8895: okl_pool_contents pcn,
8896: okl_K_headers_full_v pkhr,
8897: okl_k_headers khr
8898: where pcn.pol_id = pol.id
8899: and pcn.khr_id = khr.id
8900: and pol.khr_id = pkhr.id
8901: and pol.khr_id = agmntID

Line 8957: okl_K_headers_full_v pkhr,

8953: pkhr.contract_number agreement_number,
8954: nvl(khr.PRE_TAX_IRR, -1) contract_yield
8955: from okl_pools pol,
8956: okl_pool_contents pcn,
8957: okl_K_headers_full_v pkhr,
8958: okl_k_headers khr
8959: where pcn.pol_id = pol.id
8960: and pcn.khr_id = khr.id
8961: and pol.khr_id = pkhr.id

Line 8958: okl_k_headers khr

8954: nvl(khr.PRE_TAX_IRR, -1) contract_yield
8955: from okl_pools pol,
8956: okl_pool_contents pcn,
8957: okl_K_headers_full_v pkhr,
8958: okl_k_headers khr
8959: where pcn.pol_id = pol.id
8960: and pcn.khr_id = khr.id
8961: and pol.khr_id = pkhr.id
8962: and pol.khr_id = agmntID

Line 9742: l_stmv_rec.source_table := 'OKL_K_HEADERS';

9738:
9739: l_stmv_rec.say_code := 'CURR';
9740: l_stmv_rec.date_current := sysdate;
9741: l_stmv_rec.active_yn := 'Y';
9742: l_stmv_rec.source_table := 'OKL_K_HEADERS';
9743: l_stmv_rec.source_id := sec_strms_rec.agreement_id;
9744:
9745: print( l_api_name, ' # of streams ' || to_char( l_selv_tbl.COUNT ) );
9746: If( l_selv_tbl.COUNT > 0 AND (l_stmv_rec.sty_id IS NOT NULL) ) Then

Line 9931: l_stmv_rec.source_table := 'OKL_K_HEADERS';

9927:
9928: l_stmv_rec.say_code := 'CURR';
9929: l_stmv_rec.date_current := sysdate;
9930: l_stmv_rec.active_yn := 'Y';
9931: l_stmv_rec.source_table := 'OKL_K_HEADERS';
9932: l_stmv_rec.source_id := sec_strms_rec.agreement_id;
9933:
9934: print( l_api_name, ' # of streams ' || to_char( l_selv_tbl.COUNT ) );
9935: If( l_selv_tbl.COUNT > 0 AND (l_stmv_rec.sty_id IS NOT NULL) ) Then

Line 10346: l_stmv_rec.source_table := 'OKL_K_HEADERS';

10342:
10343: l_stmv_rec.say_code := 'CURR';
10344: l_stmv_rec.date_current := sysdate;
10345: l_stmv_rec.active_yn := 'Y';
10346: l_stmv_rec.source_table := 'OKL_K_HEADERS';
10347: l_stmv_rec.source_id := sec_strms_rec.agreement_id;
10348:
10349: If( l_selv_tbl.COUNT > 0 AND l_stmv_rec.sty_id IS NOT NULL) Then
10350:

Line 10539: l_stmv_rec.source_table := 'OKL_K_HEADERS';

10535:
10536: l_stmv_rec.say_code := 'CURR';
10537: l_stmv_rec.date_current := sysdate;
10538: l_stmv_rec.active_yn := 'Y';
10539: l_stmv_rec.source_table := 'OKL_K_HEADERS';
10540: l_stmv_rec.source_id := sec_strms_rec.agreement_id;
10541:
10542: If( l_selv_tbl.COUNT > 0 AND l_stmv_rec.sty_id IS NOT NULL) Then
10543:

Line 10971: okl_k_headers khr

10967: CURSOR c_hdr IS
10968: SELECT nvl(khr.implicit_interest_rate, 0),
10969: khr.deal_type
10970: FROM okc_k_headers_b chr,
10971: okl_k_headers khr
10972: WHERE khr.id = p_khr_id
10973: AND chr.id = khr.id;
10974:
10975: r_hdr c_hdr%ROWTYPE;

Line 11370: okl_k_headers khr

11366: khr.deal_type,
11367: khr.term_duration,
11368: NVL(khr.generate_accrual_yn, 'Y')
11369: FROM okc_k_headers_b chr,
11370: okl_k_headers khr
11371: WHERE khr.id = p_khr_id
11372: AND chr.id = khr.id;
11373:
11374: l_hdr c_hdr%ROWTYPE;

Line 11862: okl_k_headers khr,

11858: CURSOR c_hdr IS
11859: SELECT to_char(pdt.id) pid,
11860: chr.currency_code currency_code
11861: FROM okc_k_headers_v chr,
11862: okl_k_headers khr,
11863: okl_products_v pdt
11864: WHERE khr.id = chr.id
11865: AND chr.id = p_khr_id
11866: AND khr.pdt_id = pdt.id(+);