DBA Data[Home] [Help]

APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on OKL_POOLS_ALL

Line 124: ,okl_pools_all ia_pool

120: FROM okl_pool_contents ia_pool_c
121: ,okc_k_headers_all_b ia_chr
122: ,okl_k_headers ia_khr
123: ,okl_products ia_pdt
124: ,okl_pools_all ia_pool
125: WHERE ia_pool_c.sty_code = p_sty_type
126: AND ia_pool_c.pol_id = ia_pool.id
127: AND ia_pool.khr_id = ia_chr.id
128: AND ia_chr.scs_code = G_INVESTOR

Line 582: ,okl_pools_all pol

578: ,invc.START_DATE inv_agrmnt_effective_from
579: ,invc.sts_code inv_agrmnt_status_code
580: FROM okc_k_headers_all_b invc
581: ,okl_k_headers invk
582: ,okl_pools_all pol
583: WHERE invc.id = invk.id
584: AND invc.scs_code = G_INVESTOR
585: AND pol.khr_id = invk.id
586: AND invc.id = p_inv_agrmnt_id;