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_AM_TERMINATE_INV_AGMT_PVT dependencies on OKL_POOLS

Line 458: FROM OKL_POOLS POL,

454: CHR.start_date,
455: CHR.end_date,
456: CHR.sts_code,
457: CHR.date_terminated
458: FROM OKL_POOLS POL,
459: OKL_POOL_CONTENTS POC,
460: OKC_K_HEADERS_B KHR,
461: OKC_K_HEADERS_B CHR
462: WHERE KHR.id = p_ia_id

Line 544: FROM OKL_POOLS POL,

540: CURSOR check_ia_poc_date_csr (p_ia_id IN NUMBER) IS
541: SELECT 1 id
542: FROM DUAL WHERE EXISTS (
543: SELECT POC.id
544: FROM OKL_POOLS POL,
545: OKL_POOL_CONTENTS POC,
546: OKC_K_HEADERS_B CHR
547: WHERE CHR.id = p_ia_id
548: AND CHR.id = POL.khr_id

Line 563: OKL_POOLS POL,

559: SELECT SEL.id
560: FROM OKL_STREAMS STM,
561: OKL_STRM_ELEMENTS SEL,
562: OKL_STRM_TYPE_B STY,
563: OKL_POOLS POL,
564: OKL_POOL_CONTENTS POC,
565: OKC_K_HEADERS_B CHR
566: WHERE CHR.id = p_ia_id
567: AND CHR.id = POL.khr_id

Line 716: OKL_POOLS POL,

712: SELECT SEL.id
713: FROM OKL_STREAMS STM,
714: OKL_STRM_ELEMENTS SEL,
715: OKL_STRM_TYPE_B STY,
716: OKL_POOLS POL,
717: OKL_POOL_CONTENTS POC,
718: OKC_K_HEADERS_B KHR
719: WHERE KHR.id = p_ia_id
720: AND KHR.id = POL.khr_id

Line 1135: OKL_POOLS POL

1131: POL.id pool_id,
1132: POL.pool_number
1133: FROM OKC_K_HEADERS_B CHR,
1134: OKL_K_HEADERS KHR,
1135: OKL_POOLS POL
1136: WHERE CHR.id = p_ia_id
1137: AND CHR.id = KHR.id
1138: AND CHR.id = POL.khr_id;
1139:

Line 1251: OKL_POOLS POL

1247:
1248: CURSOR get_trans_pox_cont_csr (p_ia_id IN NUMBER) IS
1249: SELECT POX.id
1250: FROM OKL_POOL_TRANSACTIONS POX,
1251: OKL_POOLS POL
1252: WHERE POL.id=POX.pol_id
1253: AND POX.transaction_status <> 'COMPLETE'
1254: AND POL.khr_id =p_ia_id
1255: AND POX.transaction_type='ADD'

Line 2236: FROM OKL_POOLS POL,

2232:
2233: -- get the active pools for the IA
2234: CURSOR get_pools_csr(p_ia_id IN NUMBER) IS
2235: SELECT POL.id
2236: FROM OKL_POOLS POL,
2237: OKC_K_HEADERS_B KHR
2238: WHERE KHR.id = p_ia_id
2239: AND KHR.id = POL.khr_id
2240: AND POL.status_code = 'ACTIVE'; -- ACTIVE

Line 2247: FROM OKL_POOLS POL,

2243: -- already set to EXPIRED when control comes here )
2244: CURSOR get_pool_contents_csr(p_pol_id IN NUMBER) IS
2245: SELECT POC.id,
2246: POC.transaction_number_in
2247: FROM OKL_POOLS POL,
2248: OKL_POOL_CONTENTS POC
2249: WHERE POL.id = p_pol_id
2250: AND POC.pol_id = POL.id
2251: AND POC.status_code = 'ACTIVE';

Line 2270: FROM okl_pools pol

2266:
2267: --sosharma added cursor to fetch legal entity bug 6791390
2268: CURSOR c_pool(p_pool_id IN NUMBER) IS
2269: SELECT pol.legal_entity_id
2270: FROM okl_pools pol
2271: WHERE pol.id = p_pool_id;
2272:
2273:
2274: