[Home] [Help]
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
463: AND KHR.id = POL.khr_id
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
549: AND POL.id = POC.pol_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
568: AND POL.id = POC.pol_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
721: AND POL.id = POC.pol_id
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';
2252:
2253: -- RMUNJULU Bug 3455354
2254: -- get lease contract which is associated to this pool but not to any other ACTIVE ones
2255: CURSOR get_k_update_csr(p_pol_id IN NUMBER) IS
2256: SELECT DISTINCT POCA.khr_id
2257: FROM OKL_POOL_CONTENTS POCA
2258: WHERE POCA.pol_id = p_pol_id
2259: AND NOT EXISTS (
2260: SELECT POCB.khr_id
2261: FROM OKL_POOL_CONTENTS POCB
2257: FROM OKL_POOL_CONTENTS POCA
2258: WHERE POCA.pol_id = p_pol_id
2259: AND NOT EXISTS (
2260: SELECT POCB.khr_id
2261: FROM OKL_POOL_CONTENTS POCB
2262: WHERE POCB.pol_id <> POCA.pol_id
2263: AND POCB.khr_id = POCA.khr_id
2264: AND POCB.status_code = 'ACTIVE'
2265: );