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_POOLS

Line 63: okl_pools polb,

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
67: AND chrb.sts_code = G_STS_CODE_ACTIVE

Line 85: okl_pools polb,

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
89: AND chrb.sts_code = G_STS_CODE_ACTIVE

Line 108: okl_pools polb,

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
112: AND chrb.sts_code = G_STS_CODE_ACTIVE

Line 129: okl_pools polb,

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
133: AND chrb.sts_code = G_STS_CODE_ACTIVE

Line 232: FROM okl_pools ph

228: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
229:
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)

Line 352: okl_pools polb,

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
356: AND chrb.sts_code = G_STS_CODE_ACTIVE

Line 375: okl_pools polb,

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
379: AND chrb.sts_code = G_STS_CODE_ACTIVE

Line 398: okl_pools polb,

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
402: AND chrb.sts_code = G_STS_CODE_ACTIVE

Line 421: okl_pools polb,

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
425: AND chrb.sts_code = G_STS_CODE_ACTIVE

Line 525: FROM okl_pools ph

521: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
522:
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)

Line 656: okl_pools polb,

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
660: AND polb.khr_id = chrb.id -- inv agreement

Line 671: okl_pools polb,

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
675: AND polb.khr_id = chrb.id -- inv agreement

Line 686: okl_pools polb,

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
690: AND polb.khr_id = chrb.id -- inv agreement

Line 701: okl_pools polb,

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
705: AND polb.khr_id = chrb.id -- inv agreement

Line 821: ,okl_pools ph

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: /*
825: strm.KHR_ID = pl.KHR_ID

Line 987: ,okl_pools ph

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
991: /*

Line 1175: FROM okl_pools

1171: l_fact_synd_code fnd_lookups.lookup_code%TYPE;
1172:
1173: CURSOR ia_number (p_chr_id IN NUMBER, p_trx_date IN DATE)IS
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

Line 1189: FROM okl_pools

1185: l_count NUMBER;
1186:
1187: CURSOR ia_id (p_chr_id IN NUMBER, p_trx_date IN DATE)IS
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

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 1459: FROM okl_pools ph

1455: AND rgd.rgd_code = p_rgd_code
1456: AND rg.RULE_INFORMATION_CATEGORY = p_rdf_code -- 'LASEPR'
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

Line 1481: FROM okl_pools ph

1477: AND rgd.rgd_code = p_rgd_code
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)

Line 1668: FROM okl_pools ph

1664: AND rgd.rgd_code = p_rgd_code
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)

Line 1691: FROM okl_pools ph

1687: AND rg.RULE_INFORMATION_CATEGORY = p_rdf_code -- 'LASEPR'
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)

Line 1834: ,p_pol_id IN okl_pools.ID%TYPE

1830: PROCEDURE buyback_streams(
1831: p_api_version IN NUMBER
1832: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1833: ,p_khr_id IN okc_k_headers_b.ID%TYPE
1834: ,p_pol_id IN okl_pools.ID%TYPE
1835: ,p_stream_type_subclass IN okl_strm_type_b.stream_type_subclass%TYPE
1836: ,x_return_status OUT NOCOPY VARCHAR2
1837: ,x_msg_count OUT NOCOPY NUMBER
1838: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 1954: ,okl_pools polb

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
1958: AND pocb.pol_id = polb.id

Line 2051: ,p_pol_id IN okl_pools.ID%TYPE

2047: PROCEDURE calculate_buyback_amount(
2048: p_api_version IN NUMBER
2049: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
2050: ,p_khr_id IN okc_k_headers_b.ID%TYPE
2051: ,p_pol_id IN okl_pools.ID%TYPE
2052: ,p_stream_type_subclass IN okl_strm_type_b.stream_type_subclass%TYPE
2053: ,x_buyback_amount OUT NOCOPY NUMBER
2054: ,x_return_status OUT NOCOPY VARCHAR2
2055: ,x_msg_count OUT NOCOPY NUMBER

Line 2077: okl_pools polb

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
2080: WHERE polb.id = p_pol_id
2081: AND polb.khr_id = rulb.dnz_chr_id

Line 2097: ,okl_pools polb

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
2100: AND pocb.pol_id = polb.id
2101: AND pocb.status_code = G_POC_STS_ACTIVE

Line 2580: FROM okl_pools

2576: -- Cursor to fecth LE associated to the pool
2577: CURSOR l_okl_legal_entity_id_csr(p_pol_id NUMBER)
2578: IS
2579: SELECT legal_entity_id
2580: FROM okl_pools
2581: WHERE id = p_pol_id;
2582:
2583: -- end ankushar Legal Entity changes
2584:

Line 2923: FROM okl_pools

2919: -- Cursor to fecth LE associated to the pool
2920: CURSOR l_okl_legal_entity_id_csr(p_pol_id NUMBER)
2921: IS
2922: SELECT legal_entity_id
2923: FROM okl_pools
2924: WHERE id = p_pol_id;
2925: -- end ankushar Legal Entity Changes
2926:
2927: l_api_name CONSTANT VARCHAR2(30) := 'modify_pool_contents';

Line 3281: ,p_pol_id IN okl_pools.ID%TYPE

3277: PROCEDURE buyback_pool_contents(
3278: p_api_version IN NUMBER
3279: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
3280: ,p_khr_id IN okc_k_headers_b.ID%TYPE
3281: ,p_pol_id IN okl_pools.ID%TYPE
3282: ,p_stream_type_subclass IN okl_strm_type_b.stream_type_subclass%TYPE
3283: ,p_effective_date IN DATE
3284: ,x_return_status OUT NOCOPY VARCHAR2
3285: ,x_msg_count OUT NOCOPY NUMBER

Line 3304: FROM okl_pools

3300: -- Cursor to get the Agreement id and Legal Entity Id
3301: CURSOR l_okl_agr_csr
3302: IS
3303: SELECT khr_id, legal_entity_id
3304: FROM okl_pools
3305: WHERE id = p_pol_id;
3306:
3307: -- Cursor to check is Lease Contract
3308: -- is still securitized