APPS.OKL_AM_TERMINATE_INV_AGMT_PVT dependencies on OKL_POOLS

Line 436: FROM OKL_POOLS POL,

432: CHR.start_date,
433: CHR.end_date,
434: CHR.sts_code,
435: CHR.date_terminated
436: FROM OKL_POOLS POL,
437: OKL_POOL_CONTENTS POC,
438: OKC_K_HEADERS_B KHR,
439: OKC_K_HEADERS_B CHR
440: WHERE KHR.id = p_ia_id

Line 522: FROM OKL_POOLS POL,

518: CURSOR check_ia_poc_date_csr (p_ia_id IN NUMBER) IS
519: SELECT 1 id
520: FROM DUAL WHERE EXISTS (
521: SELECT POC.id
522: FROM OKL_POOLS POL,
523: OKL_POOL_CONTENTS POC,
524: OKC_K_HEADERS_B CHR
525: WHERE CHR.id = p_ia_id
526: AND CHR.id = POL.khr_id

Line 541: OKL_POOLS POL,

537: SELECT SEL.id
538: FROM OKL_STREAMS STM,
539: OKL_STRM_ELEMENTS SEL,
540: OKL_STRM_TYPE_B STY,
541: OKL_POOLS POL,
542: OKL_POOL_CONTENTS POC,
543: OKC_K_HEADERS_B CHR
544: WHERE CHR.id = p_ia_id
545: AND CHR.id = POL.khr_id

Line 694: OKL_POOLS POL,

690: SELECT SEL.id
691: FROM OKL_STREAMS STM,
692: OKL_STRM_ELEMENTS SEL,
693: OKL_STRM_TYPE_B STY,
694: OKL_POOLS POL,
695: OKL_POOL_CONTENTS POC,
696: OKC_K_HEADERS_B KHR
697: WHERE KHR.id = p_ia_id
698: AND KHR.id = POL.khr_id

Line 1113: OKL_POOLS POL

1109: POL.id pool_id,
1110: POL.pool_number
1111: FROM OKC_K_HEADERS_B CHR,
1112: OKL_K_HEADERS KHR,
1113: OKL_POOLS POL
1114: WHERE CHR.id = p_ia_id
1115: AND CHR.id = KHR.id
1116: AND CHR.id = POL.khr_id;
1117:

Line 1229: OKL_POOLS POL

1225:
1226: CURSOR get_trans_pox_cont_csr (p_ia_id IN NUMBER) IS
1227: SELECT POX.id
1228: FROM OKL_POOL_TRANSACTIONS POX,
1229: OKL_POOLS POL
1230: WHERE POL.id=POX.pol_id
1231: AND POX.transaction_status <> 'COMPLETE'
1232: AND POL.khr_id =p_ia_id
1233: AND POX.transaction_type='ADD'

Line 2214: FROM OKL_POOLS POL,

2210:
2211: -- get the active pools for the IA
2212: CURSOR get_pools_csr(p_ia_id IN NUMBER) IS
2213: SELECT POL.id
2214: FROM OKL_POOLS POL,
2215: OKC_K_HEADERS_B KHR
2216: WHERE KHR.id = p_ia_id
2217: AND KHR.id = POL.khr_id
2218: AND POL.status_code = 'ACTIVE'; -- ACTIVE

Line 2225: FROM OKL_POOLS POL,

2221: -- already set to EXPIRED when control comes here )
2222: CURSOR get_pool_contents_csr(p_pol_id IN NUMBER) IS
2223: SELECT POC.id,
2224: POC.transaction_number_in
2225: FROM OKL_POOLS POL,
2226: OKL_POOL_CONTENTS POC
2227: WHERE POL.id = p_pol_id
2228: AND POC.pol_id = POL.id
2229: AND POC.status_code = 'ACTIVE';

Line 2248: FROM okl_pools pol

2244:
2245: --sosharma added cursor to fetch legal entity bug 6791390
2246: CURSOR c_pool(p_pool_id IN NUMBER) IS
2247: SELECT pol.legal_entity_id
2248: FROM okl_pools pol
2249: WHERE pol.id = p_pool_id;
2250:
2251:
2252: