DBA Data[Home] [Help]

APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on OKL_POOLS

Line 780: FROM OKL_POOLS pol,

776: IA.currency_conversion_date,
777: Poc.khr_id
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)

Line 891: okl_pools pl,

887: okc_k_headers_b khr,
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

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'