APPS.OKL_ACTIVATE_CONTRACT_PUB dependencies on OKL_RBK_SELECTED_CONTRACT

Line 826: FROM okl_rbk_selected_contract rbk_khr

822: -- AND ktrx.rbr_code IS NOT NULL
823: -- AND ktrx.tcn_type = 'TRBK')
824: ------------------------------------------------*/
825: AND EXISTS (SELECT '1'
826: FROM okl_rbk_selected_contract rbk_khr
827: WHERE rbk_khr.KHR_ID = chr.id
828: AND rbk_khr.STATUS <> 'PROCESSED'); --check with debdip
829:
830: l_mass_rbk_khr VARCHAR2(1) DEFAULT '?';