DBA Data[Home] [Help]

APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on OKL_POOL_CONTENTS_V

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 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'