DBA Data[Home] [Help]

APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on OKL_POOL_CONTENTS

Line 797: okl_pool_contents_v poc,

793: -- 02-NOV-2006 ANSETHUR R12B - Legal Entity
794: ,IA.legal_entity_id
795: FROM OKL_POOLS pol,
796: okl_k_headers_full_v IA,
797: okl_pool_contents_v poc,
798: okl_k_headers_full_v LK_KHR
799: WHERE IA.Contract_number = NVL( p_inv_agr, IA.Contract_number)
800: AND IA.ID = POL.khr_id
801: AND pol.id = poc.pol_id

Line 907: okl_pool_contents plcont

903: okl_k_headers khl,
904: okc_statuses_b khs ,
905: --Added by bkatraga for bug 6983321
906: okl_pools pl,
907: okl_pool_contents plcont
908: --pgomes fix for bug 4430377
909: WHERE trunc(ste.stream_element_date) <= trunc(NVL(p_date_to, SYSDATE))
910: AND ste.amount <> 0
911: AND stm.id = ste.stm_id

Line 1383: FROM OKL_POOLS pool, okl_pool_contents_v poc, okl_strm_type_v sty

1379: SELECT 'Y'
1380: FROM dual
1381: WHERE EXISTS
1382: ( SELECT 1
1383: FROM OKL_POOLS pool, okl_pool_contents_v poc, okl_strm_type_v sty
1384: WHERE pool.khr_id = p_khr_id
1385: AND pool.id = poc.pol_id
1386: AND poc.sty_id = sty.id
1387: AND sty.stream_type_purpose = 'RESIDUAL_VALUE'