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 DUAL

Line 254: FROM dual;

250: -- Transaction Number Cursor
251: ------------------------------------------------------------
252: CURSOR c_tran_num_csr IS
253: SELECT okl_sif_seq.nextval
254: FROM dual;
255:
256: ------------------------------------------------------------
257: -- Billing Frequency Cursor
258: ------------------------------------------------------------

Line 472: -- Cursor to check if the residual value exists in the pool or not

468: l_error_message VARCHAR2(1000);
469: l_error_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
470:
471: -- fmiao for bug 4961860
472: -- Cursor to check if the residual value exists in the pool or not
473: CURSOR check_res_in_pool(p_khr_id NUMBER) IS
474: SELECT 'Y'
475: FROM dual
476: WHERE EXISTS(

Line 475: FROM dual

471: -- fmiao for bug 4961860
472: -- Cursor to check if the residual value exists in the pool or not
473: CURSOR check_res_in_pool(p_khr_id NUMBER) IS
474: SELECT 'Y'
475: FROM dual
476: WHERE EXISTS(
477: SELECT 1
478: FROM OKL_POOLS pool,
479: okl_pool_contents_v poc,

Line 484: sty.stream_type_purpose = 'RESIDUAL_VALUE'

480: okl_strm_type_v sty
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;