DBA Data[Home] [Help]

APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on OKL_POOL_CONTENTS

Line 782: okl_pool_contents_v poc,

778: -- 02-NOV-2006 ANSETHUR R12B - Legal Entity
779: ,IA.legal_entity_id
780: FROM OKL_POOLS pol,
781: okl_k_headers_full_v IA,
782: okl_pool_contents_v poc,
783: okl_k_headers_full_v LK_KHR
784: WHERE IA.Contract_number = NVL( p_inv_agr, IA.Contract_number)
785: AND IA.ID = POL.khr_id
786: AND pol.id = poc.pol_id

Line 892: okl_pool_contents plcont

888: okl_k_headers khl,
889: okc_statuses_b khs ,
890: --Added by bkatraga for bug 6983321
891: okl_pools pl,
892: okl_pool_contents plcont
893: --pgomes fix for bug 4430377
894: WHERE trunc(ste.stream_element_date) <= trunc(NVL(p_date_to, SYSDATE))
895: AND ste.amount <> 0
896: AND stm.id = ste.stm_id

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

1309: SELECT 'Y'
1310: FROM dual
1311: WHERE EXISTS
1312: ( SELECT 1
1313: FROM OKL_POOLS pool, okl_pool_contents_v poc, okl_strm_type_v sty
1314: WHERE pool.khr_id = p_khr_id
1315: AND pool.id = poc.pol_id
1316: AND poc.sty_id = sty.id
1317: AND sty.stream_type_purpose = 'RESIDUAL_VALUE'