[Home] [Help]
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
441: AND KHR.id = POL.khr_id
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
527: AND POL.id = POC.pol_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
546: AND POL.id = POC.pol_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
699: AND POL.id = POC.pol_id
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';
2230:
2231: -- RMUNJULU Bug 3455354
2232: -- get lease contract which is associated to this pool but not to any other ACTIVE ones
2233: CURSOR get_k_update_csr(p_pol_id IN NUMBER) IS
2234: SELECT DISTINCT POCA.khr_id
2235: FROM OKL_POOL_CONTENTS POCA
2236: WHERE POCA.pol_id = p_pol_id
2237: AND NOT EXISTS (
2238: SELECT POCB.khr_id
2239: FROM OKL_POOL_CONTENTS POCB
2235: FROM OKL_POOL_CONTENTS POCA
2236: WHERE POCA.pol_id = p_pol_id
2237: AND NOT EXISTS (
2238: SELECT POCB.khr_id
2239: FROM OKL_POOL_CONTENTS POCB
2240: WHERE POCB.pol_id <> POCA.pol_id
2241: AND POCB.khr_id = POCA.khr_id
2242: AND POCB.status_code = 'ACTIVE'
2243: );