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_SECURITIZATION_PVT dependencies on OKL_POOL_CONTENTS

Line 62: FROM okl_pool_contents pocb,

58:
59: -- case 1
60: CURSOR c_khr_def(p_khr_id okc_k_headers_b.ID%TYPE, p_effective_date DATE) IS
61: SELECT '1'
62: FROM okl_pool_contents pocb,
63: okl_pools polb,
64: okc_k_headers_b chrb
65: WHERE pocb.pol_id = polb.id
66: AND polb.khr_id = chrb.id -- inv agreement

Line 84: FROM okl_pool_contents pocb,

80:
81: -- case 2
82: CURSOR c_khr_gr(p_khr_id okc_k_headers_b.ID%TYPE, p_effective_date DATE) IS
83: SELECT '1'
84: FROM okl_pool_contents pocb,
85: okl_pools polb,
86: okc_k_headers_b chrb
87: WHERE pocb.pol_id = polb.id
88: AND polb.khr_id = chrb.id -- inv agreement

Line 107: FROM okl_pool_contents pocb,

103:
104: -- case 3
105: CURSOR c_khr_ls(p_khr_id okc_k_headers_b.ID%TYPE, p_effective_date DATE) IS
106: SELECT '1'
107: FROM okl_pool_contents pocb,
108: okl_pools polb,
109: okc_k_headers_b chrb
110: WHERE pocb.pol_id = polb.id
111: AND polb.khr_id = chrb.id -- inv agreement

Line 128: FROM okl_pool_contents pocb,

124: );
125: -- case 4
126: CURSOR c_khr_eq(p_khr_id okc_k_headers_b.ID%TYPE, p_effective_date DATE) IS
127: SELECT '1'
128: FROM okl_pool_contents pocb,
129: okl_pools polb,
130: okc_k_headers_b chrb
131: WHERE pocb.pol_id = polb.id
132: AND polb.khr_id = chrb.id -- inv agreement

Line 234: FROM okl_pool_contents pl

230: CURSOR c_inv_khr(p_khr_id okc_k_headers_b.id%TYPE) IS
231: SELECT ph.khr_id -- inv agreemnet id
232: FROM okl_pools ph
233: WHERE EXISTS (SELECT '1'
234: FROM okl_pool_contents pl
235: WHERE pl.pol_id = ph.id
236: AND pl.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
237: AND pl.khr_id = p_khr_id) -- lease contract id
238: ;

Line 351: FROM okl_pool_contents pocb,

347:
348: -- case 1
349: CURSOR c_kle_def(p_kle_id okc_k_lines_b.ID%TYPE, p_effective_date DATE) IS
350: SELECT '1'
351: FROM okl_pool_contents pocb,
352: okl_pools polb,
353: okc_k_headers_b chrb
354: WHERE pocb.pol_id = polb.id
355: AND polb.khr_id = chrb.id -- inv agreement

Line 374: FROM okl_pool_contents pocb,

370:
371: -- case 2
372: CURSOR c_kle_gr(p_kle_id okc_k_lines_b.ID%TYPE, p_effective_date DATE) IS
373: SELECT '1'
374: FROM okl_pool_contents pocb,
375: okl_pools polb,
376: okc_k_headers_b chrb
377: WHERE pocb.pol_id = polb.id
378: AND polb.khr_id = chrb.id -- inv agreement

Line 397: FROM okl_pool_contents pocb,

393:
394: -- case 3
395: CURSOR c_kle_ls(p_kle_id okc_k_lines_b.ID%TYPE, p_effective_date DATE) IS
396: SELECT '1'
397: FROM okl_pool_contents pocb,
398: okl_pools polb,
399: okc_k_headers_b chrb
400: WHERE pocb.pol_id = polb.id
401: AND polb.khr_id = chrb.id -- inv agreement

Line 420: FROM okl_pool_contents pocb,

416:
417: -- case 4
418: CURSOR c_kle_eq(p_kle_id okc_k_lines_b.ID%TYPE, p_effective_date DATE) IS
419: SELECT '1'
420: FROM okl_pool_contents pocb,
421: okl_pools polb,
422: okc_k_headers_b chrb
423: WHERE pocb.pol_id = polb.id
424: AND polb.khr_id = chrb.id -- inv agreement

Line 527: FROM okl_pool_contents pl

523: CURSOR c_inv_khr(p_kle_id okc_k_lines_b.id%TYPE) IS
524: SELECT ph.khr_id -- inv agreemnet id
525: FROM okl_pools ph
526: WHERE EXISTS (SELECT '1'
527: FROM okl_pool_contents pl
528: WHERE pl.pol_id = ph.id
529: AND pl.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
530: AND pl.kle_id = p_kle_id) -- lease contract id
531: ;

Line 655: FROM okl_pool_contents pocb,

651:
652: -- Cursor to check if sty is securitized ">" effective_date
653: CURSOR l_okl_sty_grt_csr IS
654: SELECT DISTINCT polb.khr_id
655: FROM okl_pool_contents pocb,
656: okl_pools polb,
657: okc_k_headers_b chrb,
658: okl_strm_type_b styb
659: WHERE pocb.pol_id = polb.id

Line 670: FROM okl_pool_contents pocb,

666:
667: -- Cursor to check if sty is securitized "<" effective_date
668: CURSOR l_okl_sty_les_csr IS
669: SELECT DISTINCT polb.khr_id
670: FROM okl_pool_contents pocb,
671: okl_pools polb,
672: okc_k_headers_b chrb,
673: okl_strm_type_b styb
674: WHERE pocb.pol_id = polb.id

Line 685: FROM okl_pool_contents pocb,

681:
682: -- Cursor to check if sty is securitized "=" effective_date
683: CURSOR l_okl_sty_eql_csr IS
684: SELECT DISTINCT polb.khr_id
685: FROM okl_pool_contents pocb,
686: okl_pools polb,
687: okc_k_headers_b chrb,
688: okl_strm_type_b styb
689: WHERE pocb.pol_id = polb.id

Line 700: FROM okl_pool_contents pocb,

696:
697: -- Cursor to check if sty is securitized ">=" effective_date
698: CURSOR l_okl_sty_geq_csr IS
699: SELECT DISTINCT polb.khr_id
700: FROM okl_pool_contents pocb,
701: okl_pools polb,
702: okc_k_headers_b chrb,
703: okl_strm_type_b styb
704: WHERE pocb.pol_id = polb.id

Line 820: ,okl_pool_contents pl

816:
817: CURSOR c_stm(p_stm_id okl_streams.ID%TYPE, p_effective_date DATE) IS
818: SELECT '1'
819: FROM okl_streams strm
820: ,okl_pool_contents pl
821: ,okl_pools ph
822: ,okc_k_headers_b khr
823: WHERE -- mvasudev, stm_id changes
824: /*

Line 986: ,okl_pool_contents pl

982: CURSOR c_sel(p_sel_id okl_strm_elements.ID%TYPE, p_effective_date DATE) IS
983: SELECT '1'
984: FROM okl_streams strm
985: ,okl_strm_elements ele
986: ,okl_pool_contents pl
987: ,okl_pools ph
988: ,okc_k_headers_b khr
989: WHERE strm.id = ele.stm_id
990: -- mvasudev, stm_id changes

Line 1178: FROM okl_pool_contents

1174: SELECT COUNT(khr_id)
1175: FROM okl_pools
1176: WHERE id IN
1177: (SELECT pol_id
1178: FROM okl_pool_contents
1179: WHERE khr_id = p_chr_id
1180: AND TRUNC(streams_from_date) <= TRUNC(p_trx_date) -- cklee 05/29/08
1181: AND (TRUNC(streams_to_date) >= TRUNC(p_trx_date) OR -- cklee 05/29/08
1182: streams_to_date IS NULL)

Line 1192: FROM okl_pool_contents

1188: SELECT khr_id
1189: FROM okl_pools
1190: WHERE id IN
1191: (SELECT pol_id
1192: FROM okl_pool_contents
1193: WHERE khr_id = p_chr_id
1194: AND TRUNC(streams_from_date) <= TRUNC(p_trx_date) -- cklee 05/29/08
1195: AND (TRUNC(streams_to_date) >= TRUNC(p_trx_date) OR -- cklee 05/29/08
1196: streams_to_date IS NULL)

Line 1206: FROM okc_k_headers_b ia,okl_pools op, okl_pool_contents opc

1202: -- cursor to get all pools to which contract is attached
1203: CURSOR csr_get_all_assoc_ia(p_chr_id IN NUMBER) IS
1204: SELECT ia.ID ia_id, ia.START_DATE ia_start_date,op.ID pool_id,opc.STY_CODE strm_type,
1205: opc.streams_from_date strm_from_date, opc.streams_to_date strm_to_date
1206: FROM okc_k_headers_b ia,okl_pools op, okl_pool_contents opc
1207: WHERE ia.ID = op.khr_id
1208: AND op.id = opc.pol_id
1209: AND opc.khr_id = p_chr_id
1210: AND opc.STATUS_CODE ='ACTIVE'

Line 1461: ,okl_pool_contents pl

1457: AND EXISTS -- investor agreement Ids
1458: (SELECT '1'
1459: FROM okl_pools ph
1460:
1461: ,okl_pool_contents pl
1462: WHERE ph.id = pl.pol_id
1463: AND pl.khr_id = p_khr_id -- lease contract id
1464: AND pl.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
1465: AND ph.khr_id = rg.dnz_chr_id) -- investor agreement contarct id

Line 1482: ,okl_pool_contents pl

1478: AND rg.RULE_INFORMATION_CATEGORY = p_rdf_code -- 'LASEPR'
1479: AND EXISTS -- investor agreement Ids
1480: (SELECT '1'
1481: FROM okl_pools ph
1482: ,okl_pool_contents pl
1483: WHERE ph.id = pl.pol_id
1484: AND pl.khr_id = p_khr_id -- lease contract id
1485: AND pl.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
1486: AND ph.khr_id = rg.dnz_chr_id) -- investor agreement contarct id

Line 1669: ,okl_pool_contents pl

1665: AND rg.RULE_INFORMATION_CATEGORY = p_rdf_code -- 'LASEPR'
1666: AND EXISTS -- investor agreement Ids
1667: (SELECT '1'
1668: FROM okl_pools ph
1669: ,okl_pool_contents pl
1670: WHERE ph.id = pl.pol_id
1671: AND pl.kle_id = p_kle_id -- lease contract top line Id
1672: AND pl.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
1673: AND ph.khr_id = rg.dnz_chr_id) -- investor agreement contarct id

Line 1692: ,okl_pool_contents pl

1688:
1689: AND EXISTS -- investor agreement Ids
1690: (SELECT '1'
1691: FROM okl_pools ph
1692: ,okl_pool_contents pl
1693: WHERE ph.id = pl.pol_id
1694: AND pl.kle_id = p_kle_id -- lease contract top line Id
1695: AND pl.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
1696: AND ph.khr_id = rg.dnz_chr_id) -- investor agreement contarct id

Line 1844: FROM okl_pool_contents pocb

1840: -- Collect Pool Contents
1841: CURSOR l_okl_poc_csr
1842: IS
1843: SELECT pocb.id
1844: FROM okl_pool_contents pocb
1845: ,okl_strm_type_b styb
1846: WHERE pocb.khr_id = p_khr_id
1847: AND pocb.pol_id = p_pol_id
1848: AND pocb.sty_id = styb.id

Line 1953: FROM okl_pool_contents pocb

1949: ,pocb.khr_id dnz_chr_id -- Lease Contract
1950: -- ,pocb.pol_id pol_id -- Pool
1951: ,pocb.kle_id kle_id -- Asset
1952: ,pocb.sty_id sty_id -- Stream Type
1953: FROM okl_pool_contents pocb
1954: ,okl_pools polb
1955: ,okc_rules_b rulb
1956: ,okc_rule_groups_v rgpb
1957: WHERE pocb.id = p_poc_id

Line 2064: FROM okl_pool_contents pocb

2060: -- also to make sure we have data
2061: CURSOR l_okl_pol_csr
2062: IS
2063: SELECT DISTINCT pocb.pol_id
2064: FROM okl_pool_contents pocb
2065: ,okl_strm_type_b styb
2066: WHERE pocb.khr_id = p_khr_id
2067: AND pocb.pol_id = p_pol_id
2068: AND pocb.sty_id = styb.id

Line 2075: FROM --okl_pool_contents pocb --changed by abhsaxen for Bug#6174484

2071: -- Cursor for Buyback Formula
2072: CURSOR l_okl_formula_csr
2073: IS
2074: SELECT rulb.rule_information1 formula
2075: FROM --okl_pool_contents pocb --changed by abhsaxen for Bug#6174484
2076: --,
2077: okl_pools polb
2078: ,okc_rules_b rulb
2079: ,okc_rule_groups_v rgpb

Line 2095: FROM okl_pool_contents pocb

2091: ,pocb.kle_id kle_id
2092: ,pocb.sty_id sty_id
2093: ,pocb.sty_code
2094: ,pocb.streams_from_date
2095: FROM okl_pool_contents pocb
2096: ,okl_strm_type_b styb
2097: ,okl_pools polb
2098: WHERE pocb.khr_id = p_khr_id
2099: AND pocb.pol_id = p_pol_id

Line 2268: FROM okl_pool_contents pocb

2264: ,pocb.sty_code
2265: ,pocb.streams_from_date
2266: ,pocb.streams_to_date
2267: ,styb.stream_type_subclass
2268: FROM okl_pool_contents pocb
2269: ,okl_strm_type_b styb
2270: WHERE pocb.pol_id = p_pol_id
2271: AND pocb.khr_id = p_khr_id
2272: AND pocb.kle_id = NVL(p_kle_id,pocb.kle_id)

Line 2300: CURSOR c_chk_buy_back_date (cp_pol_id OKL_POOL_CONTENTS.ID%TYPE

2296:
2297:
2298: -- Bug# 7590979 - Start
2299: -- Cursor gets the buy back date of a contract from a pool
2300: CURSOR c_chk_buy_back_date (cp_pol_id OKL_POOL_CONTENTS.ID%TYPE
2301: , cp_khr_id OKC_K_HEADERS_B.ID%TYPE
2302: , cp_stream_type_subclass OKL_STRM_TYPE_B.STREAM_TYPE_SUBCLASS%TYPE) IS
2303: SELECT POX.TRANSACTION_DATE
2304: FROM OKL_POOL_CONTENTS POC

Line 2304: FROM OKL_POOL_CONTENTS POC

2300: CURSOR c_chk_buy_back_date (cp_pol_id OKL_POOL_CONTENTS.ID%TYPE
2301: , cp_khr_id OKC_K_HEADERS_B.ID%TYPE
2302: , cp_stream_type_subclass OKL_STRM_TYPE_B.STREAM_TYPE_SUBCLASS%TYPE) IS
2303: SELECT POX.TRANSACTION_DATE
2304: FROM OKL_POOL_CONTENTS POC
2305: , OKL_POOL_TRANSACTIONS POX
2306: , OKL_STRM_TYPE_B STY
2307: WHERE POC.KHR_ID = cp_khr_id
2308: AND POC.POL_ID = cp_pol_id

Line 2502: Changes to stamp pox_id on okl_pool_contents

2498: END IF;
2499:
2500: lp_pocv_rec_cre.transaction_number_in := lx_poxv_rec.transaction_number;
2501: /* sosharma 26-11-2007
2502: Changes to stamp pox_id on okl_pool_contents
2503: Start Changes
2504: */
2505: lp_pocv_rec_cre.pox_id:= lx_poxv_rec.id;
2506: /* sosharma end changes*/

Line 2613: FROM okl_pool_contents pocb

2609: -- Cursor to get all the Pools associated with this Lease Contract/ Asset Line
2610: CURSOR l_okl_pol_csr
2611: IS
2612: SELECT DISTINCT pol_id
2613: FROM okl_pool_contents pocb
2614: ,okl_strm_type_b styb
2615: WHERE pocb.khr_id = p_khr_id
2616: AND pocb.kle_id = NVL(p_kle_id,pocb.kle_id)
2617: AND pocb.sty_id = styb.id

Line 2940: FROM okl_pool_contents

2936: -- Cursor to get all the Pools associated with this Lease Contract/ Asset Line
2937: CURSOR l_okl_pol_csr
2938: IS
2939: SELECT DISTINCT pol_id
2940: FROM okl_pool_contents
2941: WHERE khr_id = p_khr_id
2942: AND kle_id = p_kle_id
2943: AND status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE
2944: AND transaction_number_out IS NULL;

Line 2955: FROM okl_pool_contents

2951: ,sty_id
2952: ,sty_code
2953: ,streams_from_date
2954: ,streams_to_date
2955: FROM okl_pool_contents
2956: WHERE pol_id = p_pol_id
2957: AND khr_id = p_khr_id
2958: AND kle_id = p_kle_id
2959: AND status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE

Line 3097: Changes to stamp pox_id on okl_pool_contents

3093: lp_pocv_rec_cre.streams_to_date := l_okl_poc_rec.streams_to_date;
3094: lp_pocv_rec_cre.transaction_number_in := lx_poxv_rec.transaction_number;
3095:
3096: /* sosharma 26-11-2007
3097: Changes to stamp pox_id on okl_pool_contents
3098: Start Changes
3099: */
3100: lp_pocv_rec_cre.pox_id:= lx_poxv_rec.id;
3101: /* sosharma end changes*/

Line 3348: FROM okl_pool_contents pocb

3344: -- also to make sure we have data
3345: CURSOR l_okl_pol_csr
3346: IS
3347: SELECT DISTINCT pocb.pol_id
3348: FROM okl_pool_contents pocb
3349: ,okl_strm_type_b styb
3350: WHERE pocb.khr_id = p_khr_id
3351: AND pocb.pol_id = p_pol_id
3352: AND pocb.sty_id = styb.id

Line 3367: FROM okl_pool_contents pocb

3363: -- is still securitized
3364: CURSOR l_okl_poc_khr_csr
3365: IS
3366: SELECT 1
3367: FROM okl_pool_contents pocb
3368: WHERE pocb.khr_id = p_khr_id
3369: AND pocb.status_code = 'ACTIVE';
3370:
3371: -- cursor to get stream type purposes for a stream_type_subclass