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 300: FROM dual;

296: -- Transaction Number Cursor
297: ------------------------------------------------------------
298: CURSOR c_tran_num_csr IS
299: SELECT okl_sif_seq.nextval
300: FROM dual;
301:
302: ------------------------------------------------------------
303: -- Billing Frequency Cursor
304: ------------------------------------------------------------

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

514: l_error_message VARCHAR2(1000);
515: l_error_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
516:
517: -- fmiao for bug 4961860
518: -- Cursor to check if the residual value exists in the pool or not
519: CURSOR check_res_in_pool(p_khr_id NUMBER) IS
520: SELECT 'Y'
521: FROM dual
522: WHERE EXISTS(

Line 521: FROM dual

517: -- fmiao for bug 4961860
518: -- Cursor to check if the residual value exists in the pool or not
519: CURSOR check_res_in_pool(p_khr_id NUMBER) IS
520: SELECT 'Y'
521: FROM dual
522: WHERE EXISTS(
523: SELECT 1
524: FROM OKL_POOLS pool,
525: okl_pool_contents_v poc,

Line 530: sty.stream_type_purpose = 'RESIDUAL_VALUE'

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