APPS.OKL_AM_ASSET_RETURN_PVT dependencies on OKL_AM_REMARKET_TEAMS_UV

Line 490: FROM OKL_DF_CTGY_RMK_TMS RC, OKL_AM_REMARKET_TEAMS_UV T

486:
487: -- This cursor is used to get the remarketer
488: CURSOR l_remarketcombo_csr(p_id NUMBER) IS
489: SELECT RC.rmr_id
490: FROM OKL_DF_CTGY_RMK_TMS RC, OKL_AM_REMARKET_TEAMS_UV T
491: WHERE RC.rmr_id = T.ORIG_SYSTEM_ID
492: AND RC.ico_id = p_id
493: AND RC.date_effective_from <= SYSDATE
494: AND NVL(RC.date_effective_to, SYSDATE+1) >= SYSDATE;