eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_EVERGREEN_BILLING_PVT dependencies on OKL_POOL_PVT

Line 334: AND pol.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE; --Added by VARANGAN -Pool Contents Impact(Bug#6658065)

330: and pol.sty_id = p_sty_id
331: and trunc(p_stream_element_date) between trunc(pol.streams_from_date) and trunc(pol.streams_to_date)
332: and pol.pol_id = pool.id
333: and pool.khr_id = khr.id
334: AND pol.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE; --Added by VARANGAN -Pool Contents Impact(Bug#6658065)
335:
336: ------------------------------------------------------------
337: -- Stream Cursor
338: ------------------------------------------------------------

Line 485: AND poc.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE ); --Added by VARANGAN -Pool Contents Impact(Bug#6658065)

481: WHERE pool.khr_id = p_khr_id AND
482: pool.id = poc.pol_id AND
483: poc.sty_id = sty.id AND
484: sty.stream_type_purpose = 'RESIDUAL_VALUE'
485: AND poc.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE ); --Added by VARANGAN -Pool Contents Impact(Bug#6658065)
486:
487: l_res_in_pool VARCHAR2(1);
488: l_evrgrn_psthrgh_flg NUMBER := 0;
489: -- end fmiao for bug 4961860