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_MLA_CREATE_UPDATE_PUB dependencies on OKL_VP_ASSOCIATIONS

Line 685: AND exists( select 1 from okl_vp_associations vpaso

681: AND prl.object1_id1 = p_object1_id1
682: AND prl.object1_id2 = p_object1_id2
683: AND prl.jtot_object1_code = p_customer_code
684: AND CHR.contract_number = p_source_contract_number
685: AND exists( select 1 from okl_vp_associations vpaso
686: where vpaso.chr_id = l_prog_id);
687:
688: -- cursor when only program is selected
689: CURSOR l_source_prog_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2, l_prog_id NUMBER) IS

Line 698: AND exists( select 1 from okl_vp_associations vpaso

694: AND CHR.scs_code = p_scs_code
695: AND CHR.chr_type = 'CYA'
696: AND NVL(CHR.template_yn,'N') = p_temp_yn
697: AND CHR.contract_number = p_source_contract_number
698: AND exists( select 1 from okl_vp_associations vpaso
699: where vpaso.chr_id = l_prog_id);
700:
701: CURSOR l_src_chr_id_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2) IS
702: SELECT CHR.id