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 380: AND pol.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE; --Added by VARANGAN -Pool Contents Impact(Bug#6658065)

376: and pol.sty_id = p_sty_id
377: and trunc(p_stream_element_date) between trunc(pol.streams_from_date) and trunc(pol.streams_to_date)
378: and pol.pol_id = pool.id
379: and pool.khr_id = khr.id
380: AND pol.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE; --Added by VARANGAN -Pool Contents Impact(Bug#6658065)
381:
382: ------------------------------------------------------------
383: -- Stream Cursor
384: ------------------------------------------------------------

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

527: WHERE pool.khr_id = p_khr_id AND
528: pool.id = poc.pol_id AND
529: poc.sty_id = sty.id AND
530: sty.stream_type_purpose = 'RESIDUAL_VALUE'
531: AND poc.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE ); --Added by VARANGAN -Pool Contents Impact(Bug#6658065)
532:
533: l_res_in_pool VARCHAR2(1);
534: l_evrgrn_psthrgh_flg NUMBER := 0;
535: -- end fmiao for bug 4961860