APPS.OKL_ACTIVATE_CONTRACT_PUB dependencies on OKL_RBK_SELECTED_CONTRACT

Line 544: FROM okl_rbk_selected_contract rbk_khr

540: -- AND ktrx.rbr_code IS NOT NULL
541: -- AND ktrx.tcn_type = 'TRBK')
542: ------------------------------------------------*/
543: AND EXISTS (SELECT '1'
544: FROM okl_rbk_selected_contract rbk_khr
545: WHERE rbk_khr.KHR_ID = chr.id
546: AND rbk_khr.STATUS <> 'PROCESSED'); --check with debdip
547:
548: l_mass_rbk_khr VARCHAR2(1) DEFAULT '?';