APPS.EAM_MAINT_ATTRIBUTES_PUB dependencies on MTL_EAM_LOCATIONS

Line 436: SELECT count(*) INTO l_count FROM mtl_eam_locations

432:
433: -- Validate Area
434: IF p_area_id IS NOT NULL THEN
435: IF ( NOT(p_mode = 2 AND p_area_id = fnd_api.g_miss_num)) THEN
436: SELECT count(*) INTO l_count FROM mtl_eam_locations
437: WHERE location_id = p_area_id AND organization_id = x_org_id
438: AND sysdate BETWEEN nvl(start_date, sysdate-1) AND nvl(end_date, sysdate+1);
439:
440: IF l_count = 0 THEN