APPS.OKL_AM_ASSET_RELOCATION_PVT dependencies on FA_LOCATIONS

Line 213: FROM fa_locations

209:
210: -- This cursor is used to validate the new location Id
211: CURSOR l_location_csr(p_location_id NUMBER, p_sysdate DATE) IS
212: SELECT 'x'
213: FROM fa_locations
214: WHERE location_id = p_location_id
215: AND enabled_flag = 'Y'
216: AND p_sysdate BETWEEN NVL(START_DATE_ACTIVE,p_sysdate) AND NVL(END_DATE_ACTIVE,p_sysdate);
217: